Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
saving macros in personal workbook
On recording a macro in my personal workbook everything seems fine. If I
close down excel and reopen the macro has been deleted and the elements put into the trash can. i assume I must have a setting somewhere that is deleting the macro, but I don't know what. Please help!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
saving macros in personal workbook
You have to save the personal workbook, whenever you write a new macro to it if you want to keep it. When I close excel, after putting a macro in the personal.xls, it asks me if I want to save the file. If yours is not doing this, there may be a setting somewhere which needs to be set. another way to do it is from the view Visual Basic location. make sure one of the personal workbook items is selected then goto file and select save personal.xls "porbeagle" wrote: On recording a macro in my personal workbook everything seems fine. If I close down excel and reopen the macro has been deleted and the elements put into the trash can. i assume I must have a setting somewhere that is deleting the macro, but I don't know what. Please help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving styles into the personal workbook | Excel Discussion (Misc queries) | |||
Saving Macro to Personal Workbook | Excel Discussion (Misc queries) | |||
Saving a workbook separately to its macros | Excel Discussion (Misc queries) | |||
macros in personal.xls file | Excel Worksheet Functions | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) |