Home |
Search |
Today's Posts |
#1
|
|||
|
|||
global Macros
How do you make a Macro available to all workbooks.
|
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect macros? | Excel Discussion (Misc queries) | |||
Deleting Macros | Excel Worksheet Functions | |||
sharing macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |