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?

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


On Mon, 22 Jun 2009 11:13:02 -0700, Nat
wrote:

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?

Thanks Gord. Much appreciated.

"Gord Dibben" wrote:

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


On Mon, 22 Jun 2009 11:13:02 -0700, Nat
wrote:

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?

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).
--
future_vba_expert


"Nat" wrote:

Thanks Gord. Much appreciated.

"Gord Dibben" wrote:

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


On Mon, 22 Jun 2009 11:13:02 -0700, Nat
wrote:

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?