global Macros
 

How do you make a Macro available to all workbooks.

Store it in your personal.xls file. Here's some information:
http://www.vbaexpress.com/forum/arti...rticle&artid=8
http://www.vbaexpress.com/forum/arti...ticle&artid=18
************
Anne Troy
www.OfficeArticles.com

"GKW in GA" wrote in message
...
How do you make a Macro available to all workbooks.

Save the macro in your Personal.xls file. This is a file which opens
every time you start excel. It is normally hidden so that it only shows
up in the VBE. If you do not have a Personal.xls file the easiest way to
create one is to record a new macro and select Personal Macro Workbook
in the Store Macro In field.

Hope this helps
Rowan

GKW in GA wrote:
How do you make a Macro available to all workbooks.