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/

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/