Macro

[Guest]

if i make a macro that needs to be used by any session of excel that's open,
regardless of whether or not the spreadsheet that created the macro was open,
how would i do that?

thanks

 

[Gord Dibben]

One method...........

Stick the macro into Personal.xls and store that file in your XLSTART folder
so it opens with each session of Excel.

If you don't have a Personal.xls, go to Tools>Macro>Record New Macro.

When the dialog box appears, select "personal macro workbook" from "store
macro in"

Copy a cell from one spot to another then "stop recording".

You now have a Personal.xls to store your macros.

Hit ALT + F11 and CRTL + r to open the Project Explorer.

Find the Personal.xls and expand it. Double-click on Module1 and copy/paste
your macro in there.

Save the workbook.

ALT + Q to go back to Excel.

Close Excel and when asked to save changes in Personal.xls answer "Yes"

Re-open Excel and Personal.xls will open hidden with your macro(s) available
for all open workbooks.

Gord Dibben Excel MVP