Creating a global macro

  • Thread starter Thread starter Jack B. Pollack
  • Start date Start date
J

Jack B. Pollack

How do I create a macro that is available to all my Excel docs (like
normal.dot in Word)?
 
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
 
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
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Word to Excel: Export comments with text and line number 0
Saving a Word document as PDF from en Excel macro 2
How to call Excel add-in macro from a button… 1
Macro Properties Password Popup. 1
Setting up a macro that can be ran from any excel file. 1
Make global Macro/Add-in for all active Workbooks/Sheets 6
Pasting Selected Excel Cells into a Word Doc 1
How to force macros refer to ActiveWorkbook 2

Back
Top