Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Where (in which folder) are macros saved? And how to change location?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where (in which folder) are macros saved? And how to changelocation?
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. On Apr 5, 4:36*am, (Keith Clark) wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you change the default folder location | Excel Discussion (Misc queries) | |||
Change location of auto saved back up copy of shared workbook? | Excel Discussion (Misc queries) | |||
Assigned macros change location | Excel Discussion (Misc queries) | |||
Template Folder location | Setting up and Configuration of Excel | |||
Macros fail if file saved in another location | Excel Programming |