ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How to activate disappeared menu bar (https://www.excelbanter.com/setting-up-configuration-excel/159029-how-activate-disappeared-menu-bar.html)

Mayank

How to activate disappeared menu bar
 
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

How to activate disappeared menu bar
 
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

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


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com