| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable menu items with VBA
Under File menu, I want to disable "Save" and "Save as". Is it possible
to do with maybe a Workbook_Open()-function or something like that? -- Reclaim Your Inbox! http://www.mozilla.org/products/thunderbird/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable menu items with VBA
Hi
You can use this in the Thisworkbook module Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True End Sub Remember that this will not work if the user disable macro's -- Regards Ron de Bruin http://www.rondebruin.nl "jst_se" wrote in message ... Under File menu, I want to disable "Save" and "Save as". Is it possible to do with maybe a Workbook_Open()-function or something like that? -- Reclaim Your Inbox! http://www.mozilla.org/products/thunderbird/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How disable menu command | Excel Discussion (Misc queries) | |||
| Disable Items in Menubar | Excel Discussion (Misc queries) | |||
| Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
| Menu Items and Disable/Enable in Excel 2003 | Excel Programming | |||
| HELP - How do I disable Excels menu items so others can't use | Excel Programming | |||
Linear Mode
