Can not see the sub menu

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all
i have a file in excel XP edition, which i was working
till last week
Rigth now i am openning the file but i cannot see all the
menus
EG. I want to hide a sheet, and i am going to the format,
i can see the Sheet menu but i can not see the sub menu,
where i can choose the hide option

Can anyone help me with this?

Regards Manos
 
Manos,

Long shot, but try this in the VBE immediate window

commandbars("Worksheet Menu
Bar").Controls("Format").controls("Sheet").enabled=true

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Do you show all menus--or just the recently used ones?

Tools|Customize|Options Tab
Check always show full menus

And you could reset that worksheet menu bar via:

Tools|customize|Toolbars Tab
Select Worksheet Menu Bar
Then click Reset

You'll lose any customized changes you've made to that toolbar, though.

(Bob's reply only tries to fix the single problem. My reply may "fix" stuff
that doesn't require fixing.)
 
Manos,
I thought I sent this yesterday but I didn't see it on the server this morning.

Is your workbook protected? Tools_Protection_Protect_Workbook. In Excel 97, the submenu is greyed out when the workbook is protected, but I don't know what it does in Excel XP.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Manos wrote: -----

Dear all
i have a file in excel XP edition, which i was working
till last week
Rigth now i am openning the file but i cannot see all the
menus
EG. I want to hide a sheet, and i am going to the format,
i can see the Sheet menu but i can not see the sub menu,
where i can choose the hide option

Can anyone help me with this?

Regards Manos
 
Thanks Dave
My office hasn't seen the need to update beyond 97, and I use 2000 at home, so I'm not familiar with the little ins and outs of the latest version

Regards
Mark Graesse
(e-mail address removed)

----- Dave Peterson wrote: ----

Format|Sheet is still enabled, but the next level is greyed out

(Same as xl97.

Mark Graesser wrote
 
Back
Top