I have inserted some form controls like the command buttom in a
workbook.
I want to make the size of the controls fix.
So that if i insert and or delete the rows in the sheets, i would be
able to maintain the same size of
the controls.
If the rows are deleted, sometimes the forms are even hidden or
diminished.
However, to allow the user to make other activities, i cannot make the
sheets
protected to prevent the user from inserting or removing the rows.

right click control and pick format control. on Properties tab pick dont
move or size.


"Subodh" wrote in message
...
|I have inserted some form controls like the command buttom in a
| workbook.
| I want to make the size of the controls fix.
| So that if i insert and or delete the rows in the sheets, i would be
| able to maintain the same size of
| the controls.
| If the rows are deleted, sometimes the forms are even hidden or
| diminished.
| However, to allow the user to make other activities, i cannot make the
| sheets
| protected to prevent the user from inserting or removing the rows.

On Apr 14, 4:06*pm, "Homey" <none wrote:
right click control and pick format control. *on Properties tab pick dont
move or size.

"Subodh" wrote in message

...
|I have inserted some form controls like the command buttom in a
| workbook.
| I want to make the size of the controls fix.
| So that if i insert and or delete the rows in the sheets, i would be
| able to maintain the same size of
| the controls.
| If the rows are deleted, sometimes the forms are even hidden or
| diminished.
| However, to allow the user to make other activities, i cannot make the
| sheets
| protected to prevent the user from inserting or removing the rows.

Thanks it worked.