URGENT - File Menu!
When you commit a major blunder and you catch it before you have saved the
file, simply close the file without saving and everything will be as it was
before the blunder. If you want to save your work up to that point, then
copy it to a new workbook and when you reopen the original file, you can copy
it back. In this case, you had an out that could restore your menu to its
original state.
"steve" wrote:
I'm learning how to make cutom tool bars. I used an example I got from
J-Walk, but I accidentally named my custom menu "File". It deleted Excel's
"File" menu, now I can't get it back.
I've tried:
Application.CommandBars.FindControl(ID:=30002).Vis ible = True
Please Help!
Thanks,
Steve
|