Forum Discussion
BillDempster
Aug 15, 2022Copper Contributor
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...
anand0409
Sep 05, 2022Copper Contributor
Hi BillDempster
Try On the View tab, in the Window group, click Unhide. In the Unhide dialog box, select PERSONAL. XLSB and click OK.
- BillDempsterSep 05, 2022Copper Contributoranand0409
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 ?- BillDempsterSep 05, 2022Copper Contributoranand0409
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.- eurosobaOct 23, 2023Copper Contributor
BillDempster I still have this problem. Could you share your resolution please? Thanks