View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Lunney Bill Lunney is offline
external usenet poster
 
Posts: 68
Default Enter Excel Design Mode and Exit Design Mode

If you're talking about recording clicks to the VBA editor AFAIK this can't
be done. If you think about it there would be no point. The macro recorder
only concerns itself with recording your actions within the Excel worksheet
environment. As soon as you're into VBA you are free to do what you want.


--
Regards,


Bill Lunney
www.billlunney.com

"TKT-Tang" wrote in message
om...
The macro recorder does not appear capable of reporting the changing
phases of the duplex Design Mode.

And so, please say, the VBA code required for switching in-and-out of
the Design Mode.

Regards.