Lock controls in VBA

[poppy]

Hi Experts

Is it possible to lock controls in VBA? I have created some controls o
a spreadsheet and everytime I delete a row all the controls move up on
row as well. It would help if I could lock them in one place.

Thanx in advance

Kind Regard

 

[Jim Rech]

Select "Don't move or size with cells" on the control's context menu (right
click) Format Control dialog, Properties tab.

--
Jim Rech
Excel MVP
|
| Hi Experts
|
| Is it possible to lock controls in VBA? I have created some controls on
| a spreadsheet and everytime I delete a row all the controls move up one
| row as well. It would help if I could lock them in one place.
|
| Thanx in advance
|
| Kind Regards
|
|
| --
| poppy
| ------------------------------------------------------------------------
| poppy's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=11453
| View this thread: http://www.excelforum.com/showthread.php?threadid=319666
|

 

[poppy]

Hi Jim

I have tried right clicking my controls in design mode, I have
command buttons, 2 comboboxs and 1 textbox on my sheet, but it does no
work. I just see a four arrow curser on the control. What am I doin
wrong

 

[poppy]

Umm Hi Jim

It is working fine now. It just does not work with right click.

Thanx very much


Kind Regard