1.

Solve : Delete Recorded Macro Excel 2003?

Answer»

Made a mistake while recording a macro in Excel 2003. Want to Delete it and start again, but cannot because PERSONAL.XLS, where the macro is recorded, is hidden and I don't KNOW how to find that worksheet so that I can Unhide it, nor how to Unhide it even if I could find it.  See attached snip of message windows.  Any help greatly appreciated. Instructions I find online to delete a macro are for more recent versions of Excel, or for deleting macros that are particular to the current workbook, not for all workbooks.I found an old solution to this problem online and it works.  The Topic is Solved.  Anyone interested can read the reply from Gord Dibben at :
https://www.excelforum.com/excel-general/572299-how-do-i-delete-a-macro-in-excel-2003-button-is-greyed-out.html
Thanks, WFDHello this may help,

If you happen to have MacOS:
Open Terminal found in Finder > Applications > Utilities
In Terminal, paste the following: defaults write com.apple.finder AppleShowAllFiles YES
Press return
Hold the ‘Option/alt’ key, then right click on the Finder icon in the DOCK and click Relaunch.
Relaunch Finder by right clicking the Finder Icon WHILST holding the ‘Option/alt’ key

This will show all hidden files. To hide them again, follow the same steps but REPLACE the Terminal command with:
defaults write com.apple.finder AppleShowAllFiles NO

If you happen to have Windows, then:
In the search box on the taskbar, type folder, and then select Show hidden files and folders In the View tab from the search results.
Under Advanced settings, select Show hidden files, folders, and drives, and then select OK.



Discussion

No Comment Found