ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   SAVE and SAVE AS options disappeared from the drop down FILE menu (https://www.excelbanter.com/excel-discussion-misc-queries/149908-save-save-options-disappeared-drop-down-file-menu.html)

[email protected]

SAVE and SAVE AS options disappeared from the drop down FILE menu
 
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?


Mike H

SAVE and SAVE AS options disappeared from the drop down FILE menu
 
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?



steve_doc

SAVE and SAVE AS options disappeared from the drop down FILE menu
 
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?




All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com