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...
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.
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.
