sethdromgoole
Programmer
Hello,
I have an Excel worksheet the contains a check box and text. I highlight all the text, and the check box is included in this range. I copy the selection and paste it into a different worksheet, and only the text pastes. The controls do not paste unless I put the workbook into design mode first. I am building a macro to do this copy/paste action, so I do not want to manually select design mode every time I run the macro. Is there vba code that will put the workbook into design mode, and if not, does anyone have a suggestion on how to resolve my issue.
Thanks,
Seth Dromgoole
I have an Excel worksheet the contains a check box and text. I highlight all the text, and the check box is included in this range. I copy the selection and paste it into a different worksheet, and only the text pastes. The controls do not paste unless I put the workbook into design mode first. I am building a macro to do this copy/paste action, so I do not want to manually select design mode every time I run the macro. Is there vba code that will put the workbook into design mode, and if not, does anyone have a suggestion on how to resolve my issue.
Thanks,
Seth Dromgoole