Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Macros
Everytime I create a macro in an Excel file I am working on, after I close
the file and say open a new one or the same file the macro is no loner in the list of available Macros. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Macros
You need to store your universal macros in the PERSONAL.xls file. When you
create a macro by clicking TOOLS/MARCRO/RECORD NEW MACRO, the dialog box has a combobox that has the label "Store macro in". Drop down the list and select PERSONAL MACRO WORKBOOK. Now, everytime you open the Excel application the PERSONAL.XLS workbook opens as a hidden workbook. All the macros stored in the PERSONAL.XLS workbook are now availble for use in other Excel files. -- Kevin Backmann "MAtt" wrote: Everytime I create a macro in an Excel file I am working on, after I close the file and say open a new one or the same file the macro is no loner in the list of available Macros. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Macros
thank you, thank you, thank you
"Kevin B" wrote: You need to store your universal macros in the PERSONAL.xls file. When you create a macro by clicking TOOLS/MARCRO/RECORD NEW MACRO, the dialog box has a combobox that has the label "Store macro in". Drop down the list and select PERSONAL MACRO WORKBOOK. Now, everytime you open the Excel application the PERSONAL.XLS workbook opens as a hidden workbook. All the macros stored in the PERSONAL.XLS workbook are now availble for use in other Excel files. -- Kevin Backmann "MAtt" wrote: Everytime I create a macro in an Excel file I am working on, after I close the file and say open a new one or the same file the macro is no loner in the list of available Macros. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving and Retrieving Macros | Excel Discussion (Misc queries) | |||
Macros and saving .csv files | Excel Discussion (Misc queries) | |||
saving with macros in excell | Excel Discussion (Misc queries) | |||
Saving Macros | Excel Discussion (Misc queries) | |||
Saving Macros | Excel Worksheet Functions |