Creating a global macro

J

Jack B. Pollack

How do I create a macro that is available to all my Excel docs (like
normal.dot in Word)?
 
H

Harald Staff

Start the macro recorder. In the following dialog, field "Store macro in",
select "Personal macro workbook" and this will be generated for you on
recording. This is the place to store all general macros you need.

HTH. Best wishes Harald
 
J

Jack B. Pollack

Thanks


Harald Staff said:
Start the macro recorder. In the following dialog, field "Store macro in",
select "Personal macro workbook" and this will be generated for you on
recording. This is the place to store all general macros you need.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top