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