View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Subodh Subodh is offline
external usenet poster
 
Posts: 99
Default Fix the size of form controls in a worksheet

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.