Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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''. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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''. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
How do I use ActiveX controls to hide/show rows on a sheet? | Excel Programming | |||
multiple copy / paste on locked sheet | Excel Programming | |||
ActiveX Controls | Excel Programming |