Forum Discussion
AmyYang
Dec 28, 2021Brass Contributor
Unable to delete macro - unhide workbook
Hi, When I created a macro then tried to delete it, I got error message that I need to unhide the workbook using Unhide command. May you advise where I can do this command? Thanks, Amy
- Dec 28, 2021
Activate the View tab of the ribbon.
You should find the Unhide button in the Window group.
Click this button, select a workbook from the list, then click OK.
Alternatively, press Alt+F11 to activate the Visual Basic Editor. See if you can find the macro there. If so, simply delete its text.
HansVogelaar
Dec 28, 2021MVP
Activate the View tab of the ribbon.
You should find the Unhide button in the Window group.
Click this button, select a workbook from the list, then click OK.
Alternatively, press Alt+F11 to activate the Visual Basic Editor. See if you can find the macro there. If so, simply delete its text.
akhona1986
May 17, 2022Copper Contributor
HansVogelaar thanks. My eyes were starting to get teary because the file (the one with macros) was not opening (or showing) so I thought I had lost all that work. Thanks a million.