macro to exit design mode
I am creating protected worksheets for users. When some users open them,
their Excel is already in Design Mode. I need code to 'exit' design mode automatically. Can anyone advise please? -- cm |
macro to exit design mode
see if this helps:
Sub ExitDesignMode() With CommandBars("Exit Design Mode").Controls(1) If .State = msoButtonDown Then .Execute End With End Sub -- jb "cm" wrote: I am creating protected worksheets for users. When some users open them, their Excel is already in Design Mode. I need code to 'exit' design mode automatically. Can anyone advise please? -- cm |
macro to exit design mode
one more thing - need this to run on workbook_open -- get an error of 'with
block variable not set' -- what do I need to edit? cm "john" wrote: see if this helps: Sub ExitDesignMode() With CommandBars("Exit Design Mode").Controls(1) If .State = msoButtonDown Then .Execute End With End Sub -- jb "cm" wrote: I am creating protected worksheets for users. When some users open them, their Excel is already in Design Mode. I need code to 'exit' design mode automatically. Can anyone advise please? -- cm |
macro to exit design mode
keep the procedure in standard module and call it from open event
Private Sub Workbook_Open() Call ExitDesignMode End Sub -- jb "cm" wrote: one more thing - need this to run on workbook_open -- get an error of 'with block variable not set' -- what do I need to edit? cm "john" wrote: see if this helps: Sub ExitDesignMode() With CommandBars("Exit Design Mode").Controls(1) If .State = msoButtonDown Then .Execute End With End Sub -- jb "cm" wrote: I am creating protected worksheets for users. When some users open them, their Excel is already in Design Mode. I need code to 'exit' design mode automatically. Can anyone advise please? -- cm |
All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com