| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Global Macros
How can I create a marco to be available in all workbooks?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Global Macros
Put the code in your Personal.XLS workbook. If you are using the macro
recorder, drop open the "save in" box and choose "Personal.XLS" from the list. Then your code will be available for any workbook open. Even if you don't already have a Personal.XLS, using the macro recorder is a great and fast way to create one. HTH Richard Choate "Mark L-Z" wrote in message ... How can I create a marco to be available in all workbooks? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Global Macros
Thanx for you quick response. I tried your suggestion and it worked like
a charm (or should I say macro). It's wonderful. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Global Macros
Save a macro in your personal.xls workbook. This workbook is (usually)
loaded and hidden when you start XL. -- Michael J. Malinsky "Mark L-Z" wrote in message ... How can I create a marco to be available in all workbooks? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating macros | Excel Worksheet Functions | |||
| macros creating | Excel Discussion (Misc queries) | |||
| Global macros | Excel Discussion (Misc queries) | |||
| global Macros | Excel Discussion (Misc queries) | |||
| Creating an interactive Global Map in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
