Prev: Disabling copy/cut/paste for shapes
Next: Dynamic view of data based on cell content
From: Subodh on 14 Apr 2010 06:13
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.
From: Homey on 14 Apr 2010 07:06
right click control and pick format control. on Properties tab pick dont
move or size.


"Subodh" <getsubodh(a)gmail.com> wrote in message
news:ea77375d-0cbd-4fa3-bd6a-9e04307ac93e(a)z6g2000yqz.googlegroups.com...
|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.

From: Subodh on 14 Apr 2010 07:12
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" <getsub...(a)gmail.com> wrote in message
>
> news:ea77375d-0cbd-4fa3-bd6a-9e04307ac93e(a)z6g2000yqz.googlegroups.com...
> |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.
 | 
Pages: 1
Prev: Disabling copy/cut/paste for shapes
Next: Dynamic view of data based on cell content