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
|