Exiting Design Mode

[Josh Sale]

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

 

[Jake Marx]

Hi Josh,

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...read/thread/5cddbb6be1b1cfa8/b38a74e3235117b4

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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

 

[Josh Sale]

Thanks Jake.