| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Universaly available macros
In Excel 2002, how do you make a macro available to all
spreadsheets (not just new ones) that are opened? I have added a button to the toolbar that runs the macro, but it only runs on the workbook that it resides in. In older versions you added it to personal.xls, but I'm not sure how to do it in 2002. I don't have book.xlt on my machine either, so can't use that. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Universaly available macros
Hi Andrew!
You still record it in your Personal.xls You can see if it currently booted up using Window Unhide If you previously had one you can search for it using Explorer But in preference you might prefer converting your favorites to an Addin as that makes them easily portable to another computer. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Andrew J" wrote in message ... In Excel 2002, how do you make a macro available to all spreadsheets (not just new ones) that are opened? I have added a button to the toolbar that runs the macro, but it only runs on the workbook that it resides in. In older versions you added it to personal.xls, but I'm not sure how to do it in 2002. I don't have book.xlt on my machine either, so can't use that. Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Universaly available macros
Thanks Norman, but I don't have personal.xls. Unhide is
disabled also. -----Original Message----- Hi Andrew! You still record it in your Personal.xls You can see if it currently booted up using Window Unhide If you previously had one you can search for it using Explorer But in preference you might prefer converting your favorites to an Addin as that makes them easily portable to another computer. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Andrew J" wrote in message ... In Excel 2002, how do you make a macro available to all spreadsheets (not just new ones) that are opened? I have added a button to the toolbar that runs the macro, but it only runs on the workbook that it resides in. In older versions you added it to personal.xls, but I'm not sure how to do it in 2002. I don't have book.xlt on my machine either, so can't use that. Thanks in advance . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Universaly available macros
Record a macro, it will ask you where you want to save it, select
Personal Macro Workbook. This will create the Personal.xls for you. Jon Andrew J wrote: In Excel 2002, how do you make a macro available to all spreadsheets (not just new ones) that are opened? I have added a button to the toolbar that runs the macro, but it only runs on the workbook that it resides in. In older versions you added it to personal.xls, but I'm not sure how to do it in 2002. I don't have book.xlt on my machine either, so can't use that. Thanks in advance |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Universaly available macros
Thx norman, got it.
-----Original Message----- Hi Andrew! Good. We know where we are now. If you don't have a personal.xls you can create one. Tools Macro Record new Macro Select personal macro workbook in the dialog that follows Do a format of a cell Stop recording Alt + F11 You can now select Personal.xls in the project explorer Save You can delete the test macro that you recorded. You now have a Personal.xls file that should open every time that you open Excel. As a test, you might close Excel and Re-open and you should see that the unhide menu is now available and that if you select it you will see the Personal.xls is listed. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Andrew J" wrote in message ... Thanks Norman, but I don't have personal.xls. Unhide is disabled also. -----Original Message----- Hi Andrew! You still record it in your Personal.xls You can see if it currently booted up using Window Unhide If you previously had one you can search for it using Explorer But in preference you might prefer converting your favorites to an Addin as that makes them easily portable to another computer. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Andrew J" wrote in message ... In Excel 2002, how do you make a macro available to all spreadsheets (not just new ones) that are opened? I have added a button to the toolbar that runs the macro, but it only runs on the workbook that it resides in. In older versions you added it to personal.xls, but I'm not sure how to do it in 2002. I don't have book.xlt on my machine either, so can't use that. Thanks in advance . . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Universaly available macros
Thanks Crash
-----Original Message----- Record a macro, it will ask you where you want to save it, select Personal Macro Workbook. This will create the Personal.xls for you. Jon Andrew J wrote: In Excel 2002, how do you make a macro available to all spreadsheets (not just new ones) that are opened? I have added a button to the toolbar that runs the macro, but it only runs on the workbook that it resides in. In older versions you added it to personal.xls, but I'm not sure how to do it in 2002. I don't have book.xlt on my machine either, so can't use that. Thanks in advance . |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Universaly available macros
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
| Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
| Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Linear Mode
