File menu items missing

[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?

 

[Mike Hughes]

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

 

[Jody]

I have the passwords to unprotect it, I just don't know how to re-activate
the menu's...

 

[Lynn Schauer]

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

Lynn S

 

[J.E. McGimpsey]

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.

 

[J.E. McGimpsey]

Should have been

she can enter in the Immediate Window

 

[Immanuel]

One can simply right-click the menu bar area and choose customize...
Then follow Lynn's advice.