Creating Global Macros

[Mark L-Z]

How can I create a marco to be available in all workbooks?

 

[Richard Choate]

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

How can I create a marco to be available in all workbooks?

 

[Michael J. Malinsky]

Save a macro in your personal.xls workbook. This workbook is (usually)
loaded and hidden when you start XL.

 

[Mark Leone-Zwillinger]

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!