View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
 
Posts: 238
Default 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