hi,

I have created a command button on one of my MS Excel worksheet, but I don't
wish that others could be able to alter my command button's location; let's
say I want the command button to be placed on 150 (top), 150 (left).

Although I have tried to use the protection feature offered in Visual Basic
Editor; but this only can protect others from viewing the codes & the
properties of the button, others still can move the button using mouse click
& drag!!!!

Is there any way that the location of the button can be locked????
Please advice if anyone out there has any ideal to do so.....
Thanking in advance.

If you use a button from the control toolbox, they need to go to design mode
before they could move it. Not perfect, but it is more effort.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jac" wrote in message
...
hi,

I have created a command button on one of my MS Excel worksheet, but I
don't
wish that others could be able to alter my command button's location;
let's
say I want the command button to be placed on 150 (top), 150 (left).

Although I have tried to use the protection feature offered in Visual
Basic
Editor; but this only can protect others from viewing the codes & the
properties of the button, others still can move the button using mouse
click
& drag!!!!

Is there any way that the location of the button can be locked????
Please advice if anyone out there has any ideal to do so.....
Thanking in advance.

what actually i want is, a way to lock the button's location as the way the
codes and properties can; even in the design mode!!!
Which mean even one entered the design mode but some how he is not the
authorized person to do the editing; he has NO way to alter the button
location as well......

Could it be done in Macro????



"Bob Phillips" wrote:

If you use a button from the control toolbox, they need to go to design mode
before they could move it. Not perfect, but it is more effort.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jac" wrote in message
...
hi,

I have created a command button on one of my MS Excel worksheet, but I
don't
wish that others could be able to alter my command button's location;
let's
say I want the command button to be placed on 150 (top), 150 (left).

Although I have tried to use the protection feature offered in Visual
Basic
Editor; but this only can protect others from viewing the codes & the
properties of the button, others still can move the button using mouse
click
& drag!!!!

Is there any way that the location of the button can be locked????
Please advice if anyone out there has any ideal to do so.....
Thanking in advance.

Can't you just protect the worksheet ?

NickHK

"Jac" wrote in message
...
what actually i want is, a way to lock the button's location as the way
the
codes and properties can; even in the design mode!!!
Which mean even one entered the design mode but some how he is not the
authorized person to do the editing; he has NO way to alter the button
location as well......

Could it be done in Macro????



"Bob Phillips" wrote:

If you use a button from the control toolbox, they need to go to design
mode
before they could move it. Not perfect, but it is more effort.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jac" wrote in message
...
hi,

I have created a command button on one of my MS Excel worksheet, but I
don't
wish that others could be able to alter my command button's location;
let's
say I want the command button to be placed on 150 (top), 150 (left).

Although I have tried to use the protection feature offered in Visual
Basic
Editor; but this only can protect others from viewing the codes & the
properties of the button, others still can move the button using mouse
click
& drag!!!!

Is there any way that the location of the button can be locked????
Please advice if anyone out there has any ideal to do so.....
Thanking in advance.