Locking button to a cell/range

[Nacho Nachev]

Hello,

I have a button on a worksheet that has to stay always in the boundaries of
the cell/range I put it on. I.e. I need lo somehow "lock" it to the
cell/range.

Which is to correct way to do it programattically?

Thank you for your time,
Nacho

 

[Jim Rech]

Assuming you're asking about a command button from Control Toolbox or a
button from the Forms toolbar, you can prevent a user from selecting and
moving it by protecting the worksheet (Tools, Protection, Protect Sheet).

If you're asking about a toolbutton on a toolbar, these are intended to
float above the worksheet, not to be tied down to a particular cell.

--
Jim Rech
Excel MVP
| Hello,
|
| I have a button on a worksheet that has to stay always in the boundaries
of
| the cell/range I put it on. I.e. I need lo somehow "lock" it to the
| cell/range.
|
| Which is to correct way to do it programattically?
|
| Thank you for your time,
| Nacho
|
|

 

[Nacho Nachev]

It's a Control Toolbox button. This will disable modifications of the whole
worksheet, which is unwanted in my case. I guess there is not other way, so
I should put up with this.

Thanks,
Nacho