Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to disable the File/Save menu item once a workbook is opened,
forcing a person to save the file under another name. I have code (see below) to disable the File/Save As menu item, but cannot make one work for disabling just File/Save. Can anyone assist with this? Sub DisableSaveAsMenuItem() With CommandBars("Worksheet Menu Bar") With .Controls("File") .Controls("Save As....").Enabled = False End With End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
menu / toobar item for open file by name | Excel Discussion (Misc queries) | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
Setting Onaction for File Save on Menu bar using item or index numbers | Excel Programming | |||
Disabling Menu Item | Excel Programming | |||
Disable File-Save menu item in macro? | Excel Programming |