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

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

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

You can try this

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


Fan924;544981 Wrote:
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

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149956

<a href="http://www.thecodecage.com">Microsoft Office Help</a>