How to activate disappeared menu bar

[Guest]

All the menubar & toolbars have dissappered. How to get them back. Not able
to use the menu iitems using short cut keys also. The right click is disabled.
Please help

 

[Bob Phillips]

Goto the VBIDE (Alt-F11), open the immediate window (Ctrl-G), and type

Application.Commandbars("Worksheet menu Bar").enabled = True

you should be able to customize from there.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

Just a typo correction:

Application.Commandbars("Worksheet menu Bar").enabled = True

(removed an extra space character between "menu" and "bar".)