Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
Whenever I try to create a macro in the Personal Macro Workbook, I always get
the message that reads "Personal Macro Workbook in the startup folder must stay open for recording." followed by another message "Unable to record". As a result, I can't record a macro. How does one resolve this problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
I wonder if excel thinks that your personal.xls* file is corrupted and
quarantined/disabled it. In xl2003 menus, you can use: help|about microsoft excel|disabled items In xl2007, I _think_ it's under: Office button|Excel Options|Addins select disabled items from the dropdown at the bottom of that window. You can "undisable" it--but if the file is really bad, you may find that you have to delete it and use a backup version of the file. Mark wrote: Whenever I try to create a macro in the Personal Macro Workbook, I always get the message that reads "Personal Macro Workbook in the startup folder must stay open for recording." followed by another message "Unable to record". As a result, I can't record a macro. How does one resolve this problem? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros inside macros, and pasting into macro code. | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming |