Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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> |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Excel keeps asking for save when user closes system with "Macros Disabled" logic | Excel Programming | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
Disable "Save" &/or "Close" | Excel Programming |