Disable menu items with VBA

J

jst_se

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?
 
R

Ron de Bruin

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
 
Top