ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I uhide the MENU bar? (https://www.excelbanter.com/excel-discussion-misc-queries/47933-how-do-i-uhide-menu-bar.html)

Robert

How do I uhide the MENU bar?
 
I had been using the MACRO tutorial s on line.

After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc

Dave Peterson

I don't know what the tutorials did, but you may want to try:

Tools|customize
put a check mark in front of "worksheet menu bar"

If that doesn't work...
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true

Then back to excel to see if that helped.

Robert wrote:

I had been using the MACRO tutorial s on line.

After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc


--

Dave Peterson

Robert

Dave Thank you very much for responding to my predicament.
After several attempts and getting frustrated your first suggestion worked
after resetting the "worksheet menu bar"

Back on track, thankyou.

"Dave Peterson" wrote:

I don't know what the tutorials did, but you may want to try:

Tools|customize
put a check mark in front of "worksheet menu bar"

If that doesn't work...
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true

Then back to excel to see if that helped.

Robert wrote:

I had been using the MACRO tutorial s on line.

After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc


--

Dave Peterson



All times are GMT +1. The time now is 04:28 PM.

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