disable "save" and "save as" when macros are disabled

[Fan924]

When in design mode, macros are disabled and my Workbook_BeforeSave
security does not work. Any way to disable "save" and "save as" when
in design mode? Or better enable "save" and "save as" only when macro
Workbook_BeforeSave is running? excel97

 

[Simon Lloyd]

You can try thi

Code
-------------------
Private Sub Workbook_BeforeSave _(ByVal SaveAsUI As Boolean, Cancel As Boolean
If SaveAsUI = True Then Cancel = Tru
End Su
-------------------

When in design mode, macros are disabled and my Workbook_BeforeSav
security does not work. Any way to disable "save" and "save as" whe
in design mode? Or better enable "save" and "save as" only when macr
Workbook_BeforeSave is running? excel9

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com