How to copy ActiveX Controls which are locked on a sheet

R

ryguy7272

I have a couple buttons and a CheckBox on a row; all are ActiveX Controls.
I’m trying to insert a row (lots of other things going on below) and then
copy/paste the row above into the current (ActiveCell) row. I want to bring
in the RadioButtons and the CheckBoxes down one row. It seems to work when I
am in design mode, but when I get out of design mode, the controls are
locked. Actually, this is what I want (I don’t want users moving controls
around on the sheet). I don’t know if I can programmatically get into Design
Mode, that’s the problem. Or, I’d be happy to use Form Controls, but they
would have to be locked down on the sheet.

How can this be done in code?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grouping Radio Buttons; Using ActiveX Controls 2
Fire event code with Hyperlink and copy/paste RadioButtons 3
Loop thru sheets copy and then paste in other sheet 2
modifying merge all workbooks.. 3
xlFillDefault, based on values in ColA to ColZ 6
Copy Two Columns of Flat File to Final Excel File 1
Copy from one Sheet and Paste to Another 4
Complex Compare Values, and Copy/Paste if in One Sheet but Not Oth 2

Top