View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Davidson Robert Davidson is offline
external usenet poster
 
Posts: 1
Default Programmatically copying range in design mode

Manually I can switch to design mode, copy a range full of form controls and
paste it to another area. If I do not switch to design mode, it does not copy
the controls.

I would like to do this programmatically. Is there any way to enter design
mode through VBA? Record macro doesn't help, and searching XL VBA help for
design mode doesn't show anything I recognize as promising.

Many thanks,

Robert Davidson