Where (in which folder) are macros saved? And how to change location?

  • Thread starter Thread starter Keith Clark
  • Start date Start date
K

Keith Clark

When I hit in an open Excel sheet ALT+F8 the macro dialog pops up and the
user can create a new macro (which can later be started).

Where (in which folder) is this macro physically stored?
Or is it stored in/with the current Excel file itself?

If it is stored outside: How can I change this default save directory for
all Macros of all Worksheets?

If it is stored inside the current Worksheet:
Is there a way of storing it outside so that the same macro can be called in
other Excel Workbooks as well?

Keith
 
Macros are normally stored within the excel file. However you can save
it in a public folder called PERSONAL.XLS
When you record the macro you can save in Personal Macro Workbook.
 

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

Unwanted workbooks on startup 2
How to force macros refer to ActiveWorkbook 2
Macro for all Excel Workbooks to print to PDF 2
Lose macros before saving 4
How to call Excel add-in macro from a button… 1
Save All Worksheets as CSV 7
How to store values in excel using macro ? 4
How to call module function or sub from the Add In? 3

Back
Top