Macro not with a file

  • Thread starter Thread starter Mark
  • Start date Start date
You don't <g>.

If you are asking how you get a macro to apply to all workbooks and not just
a particular workbook, you put the macro in a workbook in the XLSTART
folder. It will open automatically when you start Excel. Most people use the
Personal Macro Workbook for this purpose, which is a hidden workbook called
"personal.xls" in the XLSTART folder.
 
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

Run Macro If Cell have "x" value 0
How to force macros refer to ActiveWorkbook 2
Run macro from active workbook whose name keeps changing 20
application.activesheet, should I use it? 3
Private Macros 3
How to call Excel add-in macro from a button… 1
Macros problem closing another file 0
How to Unlock Excel Workbook protected by MACRO Password 6

Back
Top