saving a new macro in Excel 07

N

Nat

Just a quick question. If I create a new macro in 07, how do I save it so
that it can be used in all workbooks not just the open workbook?
 
G

Gord Dibben

Either place the macro(s) in a new workbook and save it as an Add-in or
place the macro(s) in your Personal.xlsb workbook.

Of course you may have to edit your macro if any hard-coded sheetnames or
other stuff.

Use Activeworkbook and ActiveSheet in place of hard-coded names.


Gord Dibben MS Excel MVP
 
N

Nat

Thanks Gord. Much appreciated.

Gord Dibben said:
Either place the macro(s) in a new workbook and save it as an Add-in or
place the macro(s) in your Personal.xlsb workbook.

Of course you may have to edit your macro if any hard-coded sheetnames or
other stuff.

Use Activeworkbook and ActiveSheet in place of hard-coded names.


Gord Dibben MS Excel MVP
Click to expand...
 
F

future_vba_expert

You can also export it to a .bas file, then import it into another
spreadsheet from there (this is in Excel 2003, but I assume there is
something similar in 07).
 
Top