Fix the size of form controls in a worksheet

  • Thread starter Thread starter Subodh
  • Start date Start date
S

Subodh

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.


|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.


|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.
Click to expand...

Thanks it worked.
 
Back
Top