View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to activate disappeared menu bar

Just a typo correction:

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

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

Bob Phillips wrote:

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)

"Mayank" wrote in message
...
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


--

Dave Peterson