How to copy ActiveX Controls which are locked on a sheet
in [Programming]
|
From: ryguy7272 on 6 May 2010 16:04 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! -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''.
From: ryguy7272 on 7 May 2010 16:41 For anyone who is interested, I found a solution here: 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. > 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! > > > -- > Ryan--- > If this information was helpful, please indicate this by clicking ''Yes''.
|
Pages: 1 Prev: Photo in a sheet Next: Any help with inserting, copying and transferring data. |