File menu items missing

  • Thread starter Thread starter Jody
  • Start date Start date
J

Jody

I have a sheet that is protected and some of the file menu items are
missing.

the file menu only has these entrys...


File Edit View Window


How do i get the rest to show up?
 
Jody,

If the file is protected then it seems likely whoever protected it hid those
menu options for a reason using code in the workbook. Speak to whoever has
the password to unprotect the worksheet(book) and ask for the menu options
to be re-activated. I suspect the authot will refuse but at least you'll
know why they are missing.

Mike
 
on the Tools menu choose Customize,
select the Worksheet Menu Bar and choose Reset

Lynn S
 
This will probably be difficult for the OP sine the only menu items
available are File, Edit, View and Window.

However, if she types option-F11 to enter the VBE, she can enter

Application.ActiveMenuBar.Reset

to accomplish the same thing.
 
One can simply right-click the menu bar area and choose customize...
Then follow Lynn's advice.
 
Back
Top