Creating a global macro

[Jack B. Pollack]

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

 

[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

 

[Jack B. Pollack]

Thanks

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