How to copy ActiveX Controls which are locked on a sheet
 

I have a couple buttons and a CheckBox on a row; all are ActiveX Controls.
Im 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 dont want users moving controls
around on the sheet). I dont know if I can programmatically get into Design
Mode, thats the problem. Or, Id 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!


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

How to copy ActiveX Controls which are locked on a sheet
 

For anyone who is interested, I found a solution he
http://www.ozgrid.com/forum/showthread.php?t=51508


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ryguy7272" wrote:

I have a couple buttons and a CheckBox on a row; all are ActiveX Controls.
Im 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 dont want users moving controls
around on the sheet). I dont know if I can programmatically get into Design
Mode, thats the problem. Or, Id 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!


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.