Forum Discussion
Cannot delete a macro
Windows 10 desktop computer, Excel I recorded a macro, seems to have an error. Want to Delete it and try again. When I go into Macros, I see it listed and highlighted (it is the only one), try to cl...
Hi BillDempster
Try On the View tab, in the Window group, click Unhide. In the Unhide dialog box, select PERSONAL. XLSB and click OK.
anand0409
Thank you. I also finally figured that out and succeeded to delete the badly recorded macro. Now, trying to start fresh and record the macro again, I came to the next problem:
Developer --> Record Macro gives me window where I
Enter Macro Name
Shortcut Key
Store Macro In : (I select Personal Macro Workbook)
Now, I get the error :
"Personal Macro Workbook in the startup folder must stay open for recording"
The only thing possible to do here is to click [OK], which then gives:
"Unable to record"
And, again, cannot do anything but click [OK].
Then I look in Help under
"Open Personal Macro Workbook", which tells me to
Click Developer --> Stop Recording.
"and Excel will have created your Personal Macro Workbook"
BUT : There is no button "Stop Recording" within Developer, so I can't do that and, apparently, there is no Personal Macro Workbook, so I can't proceed. What is missing here ?
Thank you. I also finally figured that out and succeeded to delete the badly recorded macro. Now, trying to start fresh and record the macro again, I came to the next problem:
Developer --> Record Macro gives me window where I
Enter Macro Name
Shortcut Key
Store Macro In : (I select Personal Macro Workbook)
Now, I get the error :
"Personal Macro Workbook in the startup folder must stay open for recording"
The only thing possible to do here is to click [OK], which then gives:
"Unable to record"
And, again, cannot do anything but click [OK].
Then I look in Help under
"Open Personal Macro Workbook", which tells me to
Click Developer --> Stop Recording.
"and Excel will have created your Personal Macro Workbook"
BUT : There is no button "Stop Recording" within Developer, so I can't do that and, apparently, there is no Personal Macro Workbook, so I can't proceed. What is missing here ?