Enable macro in all spreadsheets

[RANDY LIPOSKY]

I have a macro in my toolbar that I would like applied to all of my spreadsheets. When I select the macro button, the spreadsheet that I originally generated the macro in opens, and then the macro runs. Instead of opening that original spreadsheet everytime I want to run the macro, is there a way of having it available for all spreadsheets?

Thanks for the help in advance!

[moonsaga]

Put the macro in your "personal.xlsb" workbook and make a tool bar button for it.

[mehmetcik]

Hi Randy.

Try this:-

Record a new macro [ Something short like select a1 ]. with the macro name that you want to use. BUT....... Make sure that when you record it specify that you want it recorded in your personal workbook.


Now copy the code in your original macro.

now select the edit option for the macro in your personal workbook. select visualbasic - macros - edit.

paste your code inside the new macro. now close visual basic.

Ok that macro is always available whenever excel is open.

BUT. Please make sure you put some code to check that it only runs in the right spreadsheet.

ALSO. You can select a shortcut to start the macro. something like ctrl a or ctrl shift a.