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.