C
Carl LaFong
I am a complete novice with macros, but have been playing with some simple
examples.
I have a macro created that I want to delete, but when I navigate to
developer/macros and choose the macro, I am told I can't delete it because
it resides in the hidden personal macro workbook file (personal.xlsb). It
says to use the unhide command in order to delete the macro, but I can't
find that particular command.
Some unhide commands are at home/cells/format dropdown, but I don't see
anything relevant. There is no workbook choice. Not even a greyed out
workbook choice. Which might lead me to believe I have no hidden workbooks,
but nonetheless I get the message to unhide.
I see some hide choices at view/show-hide, but nothing relevant.
I also notice I have a blank worksheet at the end of my Excel file titled
simply "sheet 1". Is this related to macros and can it be deleted?
examples.
I have a macro created that I want to delete, but when I navigate to
developer/macros and choose the macro, I am told I can't delete it because
it resides in the hidden personal macro workbook file (personal.xlsb). It
says to use the unhide command in order to delete the macro, but I can't
find that particular command.
Some unhide commands are at home/cells/format dropdown, but I don't see
anything relevant. There is no workbook choice. Not even a greyed out
workbook choice. Which might lead me to believe I have no hidden workbooks,
but nonetheless I get the message to unhide.
I see some hide choices at view/show-hide, but nothing relevant.
I also notice I have a blank worksheet at the end of my Excel file titled
simply "sheet 1". Is this related to macros and can it be deleted?