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.