ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I find the Worksheet Menu bar in Excel if that is missing? (https://www.excelbanter.com/excel-discussion-misc-queries/67001-how-do-i-find-worksheet-menu-bar-excel-if-missing.html)

wbez

How do I find the Worksheet Menu bar in Excel if that is missing?
 


Bob Phillips

How do I find the Worksheet Menu bar in Excel if that is missing?
 
Go to the VBIDE (Alt-F11), open the immediate window (Ctrl-G) and type

Application.Commandbars(1).Enabled = True

and Enter

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"wbez" wrote in message
...




wbez

How do I find the Worksheet Menu bar in Excel if that is missi
 
Thanks, work like a bomb.

"Bob Phillips" wrote:

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

Application.Commandbars(1).Enabled = True

and Enter

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"wbez" wrote in message
...





Bob Phillips

How do I find the Worksheet Menu bar in Excel if that is missi
 
What, you mean it blew your PC up. Sorry <vbg

Bob

"wbez" wrote in message
...
Thanks, work like a bomb.





GT

How do I find the Worksheet Menu bar in Excel if that is missi
 
Thanks bob, after 2 hours of frustration, that worked like a dream! GT

"Bob Phillips" wrote:

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

Application.Commandbars(1).Enabled = True

and Enter

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"wbez" wrote in message
...






All times are GMT +1. The time now is 08:36 PM.

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