thaking
Reputation: 3635
Excel VBA Macro "run/open" macro on any workbook
How can I write macro in Excel that will work (to run with shortcut) on any excel document which I will open?
Is this possible?
Upvotes: 1
Views: 1820
Answers (1)
Buddha
Reputation: 4476
You need to add your macros to Personal.xlsb in order to make them available to all the excel files. Choose Personal Macro Workbook in Record Macro dialog to do this quickly.
Upvotes: 4
Related Questions
- How can I open a macro workbook with VBA?
- run macro when open workbook
- Run Macro in Excel AFTER opening a Workbook
- VBA : Run a macro FOR another workbook (not from)
- Automatically run macro when opening workbook?
- Open another workbook with vba that contains all the macros
- Run VBA macro whenever any workbook is opened
- Excel vba auto run macro on workbook open
- Excecute macro on any desired workbook/spreadsheet using a command button
- Run Macro for any Active or Open Workbook?