SAVE and SAVE AS options disappeared from the drop down FILE menu

B

baltus.leroux

Hope someone can assist as my knowledge of Excel is limited. We have a
user whose SAVE and SAVE AS options "disappeared" from the FILE drop
down menu. Any ideas on how to get these back please, and maybe what
could have possibly caused it?
 
M

Mike H

Menu items can disappear if you open a workbook that disables then and
doesn't re-enable, Try this:-

Sub reset()
Application.CommandBars("Worksheet Menu Bar").reset
End Sub

Alt+F11 paste it in and run it

Mike
 
S

steve_doc

Hi

Is this only happening with certain workbooks, or is it with every workbook
for that user. If another user opens the same workbook, do they have the save
and save-as options?

a possible cause is a macro that disables those options - especially if it
is only happening on certain workbooks.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top