Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Global macros
I need to record a global macro -- one that is available in all worksheets of
all Excel 2003 workbooks on my computer. Any suggestions? -- Ken Elder University of Oklahoma |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Global macros
Record the macro and store it in your Personal.xls file.
Dave -- Brevity is the soul of wit. "Ken" wrote: I need to record a global macro -- one that is available in all worksheets of all Excel 2003 workbooks on my computer. Any suggestions? -- Ken Elder University of Oklahoma |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Global macros
Ken
When you start recording a dialog pops up allowing you to name the new macro and where to put it. Choose Personal Macro Workbook. If you don't have one, Excel will create it and store it in XLSTART folder. When you start Excel, Personal.xls will also open giving you Global macros. You can hide Personal.xls through WindowsHide. Save and it will open hidden but available. Gord Dibben MS Excel MVP On Fri, 5 Jan 2007 13:21:00 -0800, Ken wrote: I need to record a global macro -- one that is available in all worksheets of all Excel 2003 workbooks on my computer. Any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Global macros
See this page Ken
http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ken" wrote in message ... I need to record a global macro -- one that is available in all worksheets of all Excel 2003 workbooks on my computer. Any suggestions? -- Ken Elder University of Oklahoma |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros Don't Show On Commands List and 'Normal.dot' | Excel Worksheet Functions | |||
Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
global Macros | Excel Discussion (Misc queries) |