View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Flemming[_2_] Flemming[_2_] is offline
external usenet poster
 
Posts: 26
Default Turn ON design mode...

Thanks Tom



"Tom Ogilvy" wrote in message
...
this worked in US English version:

Sub ABC()
Application.CommandBars("Control Toolbox" _
).Controls("&Design Mode").Execute
End Sub

You might need to identify the ID of the control and use FindControl to
return a reference to it, then use the reference to execute it.

--
Regards,
Tom Ogilvy


"Flemming" wrote:

Hi,

When my macro runs I at some point wants to change into design mode -
knowing that I properly can not get back to run mode with out a manual
act.

Anybody know the code to switch to design mode?

Thanks,
Flemming