Confine Activex button in Excel

[holgi123]

Hi there,

I have a button on an Excel spreadsheet with some VBA code. On click it changes the location as well as the caption.
I have tried many ways to limit the movement of the button after the click event to a certain range, i.e. "D5:G10" but so far not successful.

Could someone may be give me an idea as to how to do this?

Many thanks for any help.

 

[SkipVought]

Hi,

In design mode, right-click the control and select Format Control - Properties Tab.

Select the appropriate Object Positioning option.


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[holgi123]

Thank You for your suggestion.

However I could only find the Properties Tab on a Form Control and not an an ActiveX Control.

Any other idea how to solve this?

Thank You again for your help.

 

[xlbo]

You need to be in design mode 1st. To get there, click on the turquoise "set square" in the VBA toolbar

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question