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 ?
- anand0409
Finally figured it out after finding another Help article. Sorry to be so dense ...duhh... , but in the end succeeded in recording the macro I want and it works. Thanks for taking the time to chime in, it helped me find what I needed. Some of the Microsoft Help notes are missing important details.BillDempster I still have this problem. Could you share your resolution please? Thanks
Sorry, it has been a year since all that happened and I don't now recall what I did. However, the whole thread has a lot of discussion. Possibly if you read it very carefully, you will be able to figure it out, particularly near the end - I think there are some clues that may help, but I just don't remember. Sorry.
