Exiting Design Mode
 

Is there a way in VBA to take the worksheet out of design mode (i.e., View |
Toolbars | Control Toolbox | Design Mode)? If not, is there at least a way
to tell if the worksheet is in design mode?

TIA,

josh

Exiting Design Mode
 

Hi Josh,

Josh Sale wrote:
Is there a way in VBA to take the worksheet out of design mode (i.e.,
View | Toolbars | Control Toolbox | Design Mode)? If not, is there
at least a way to tell if the worksheet is in design mode?

Check out Jim Rech's answer in this previous thread:

http://groups-beta.google.com/group/...8a74e3235117b4

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Exiting Design Mode
 

Thanks Jake.