Accidentally deleted my Tools Menu
Posted by Mo on January 02, 2001 1:20 PM
I was working on excel and I accidentally deleted my tools menu. I dont know how to get it back. I first tried to close the workbook, hoping it would not save the changes, but sods law says those things are changed even though you did not request them to be saved permanently.
My second remedy was to re-install office, but guess what?, the new settings were changed.
Now I know there is a simple procedure that one does in a few seconds, and everything goes back to normal, unfortunately I'm not aware of it.
Basically all I want is to have my tools menu back on top of the excel spreadsheet, where i will be able to protect my work, do auditing, & add-ins etc.
thank you in advance for your help, and I apologise in advance for my Primitive question.
Posted by Tim Francis-Wright on January 02, 2001 1:32 PM
I've recovered from similar adventures by executing the following VBA command in the
immediate pane in the VB Editor:
Application.CommandBars("WorkSheet Menu Bar").Reset
It seems to do the trick. Good luck!
Posted by Mo on January 02, 2001 1:46 PM
Hi Tim, I know nothing about VBA or macros. When I wrote about running procedures, I meant it in the normal english sense of the word. I guess you could run me through the steps. I have office 2000. By the way, since its my tools menu that is missing, how am I supposed to run VBA?
Thankyou in advance for your help
Posted by Loren on January 02, 2001 1:50 PM
CLick View-Toolbars and put back anything you want.
Posted by Dave on January 02, 2001 3:00 PM
Hi Mo
Push Alt+F11 then go to Insert>Module and paste in this code:
Sub Restore()
Application.CommandBars("WorkSheet Menu Bar").Reset
'OR
Application.CommandBars("WorkSheet Menu Bar").Enabled = True
End Sub
Now with your mouse insertion point anywhere within the code push F5
Now push Alt+Q and it should be back, if so Save.
Good luck
Dave
- OzGrid Business Applications
Posted by Mo on January 02, 2001 3:13 PM
Thank you very much dave for your kind help, I tell you what I shall avoid the right button in a mouse anywhere near a menu option. Didn't know they were so much hassle, to be avoided like the plague. cheers
