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?

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

" wrote:

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?

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

" wrote:

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?