ADDING A MACRO TO THE TOOLBAR

[dbpcar]

I have a macro that formats a stock number-the stock number is alphanumeric and the macro separates the numbers and letters. It is set to run as an equation in the workbook. I have to open the workbook that contains this macro to use it, I would like to set it as a either a button on my toolbar or as an equation (this is my preference), so that it can be used in any workbook. Any suggestions?
dbpcar

 

[xlhelp]

For the macro to be available at any time you need to put it in a module in the PERSONAL.XLS workbook. Hopefully you know how to do that.

Then under Tools, Customize, Commands tab, Choose Macros and Custom Button; drop it on your Toolbar, close dialog box; double click on the button and attach your Macro.

Indu