Button Issues - moving, resizing and worse

I tend to notice this happening if the file is opened on a computer with a different screen resolution set up than the one the file was created on, or if the screen resolution is changed in some way like attaching it to a projector or similar.

Not ideal, but one way around it is adding a little code to the start of your existing code. Something like:

Please Login or Register  to view this content.

Hope that helps in some way...

BSB

MatrixMan / BadlySpelledBuoy - thank you both for the suggestions. I'm actually going to use both of them to see if it helps!

If you are using ActiveX buttons put them on a UserForm - problem solved.
torachan.

torachan - thanks... I had them on a form to begin with but the users prefer them on the worksheet - my next step, if the above solutions don't remedy the situation, will be to return to a form, OR create a custom ribbon with the functionality accessible via various buttons there.

Try the attached approach and see if this solves the problem.
The code is in the worksheet module.
As soon as you click on any cell in the visible window of sheet 1 the buttons will locate themselves.
Also in the code all the attributes can be reset.
Hope this is of some use to ActiveX fans.
torachan.

Originally Posted by torachan

Hope this is of some use to ActiveX fans.

As clever as this approach is for making things buttons stay put, I am an ActiveX fan and I often develop Excel based tools with complex landing pages that contain large numbers of buttons.

You can guarantee I'd write the code to position them all nicely then the end users would want another button added right in the middle of all the others which would of course mean I'd have to rewrite lots of code.

That's why I go for the approach I mentioned in post #3. It's never failed to keep the buttons in place and appropriately sized when switching resolution, computers or even when switching OS on the same computer. Those very simple lines of code do the job effectively and without firing a lengthy sub every time I select a different cell. And when I am asked to add a new button I can just drag/drop design, add the new button and away I go without tinkering around with code for previously place controls.

Just my tuppence worth.

BSB

@JP Romano.
Despite developing spreadsheets and applications since the advent of VisiCalc & Lotus123 I am still learning
On re-reading your post

If I click button A, while the mouse is depressed it partially overlays Button B and doesn't execute the macro

I now have to presume it is .xlsm file, documentation exists that in the past that ActiveX (on sheet rather than on UserForms) and macros are bad companions.
Could this possibly be a hidden source of the problem.
torachan.

Or just use shapes...

(or forms controls as mentioned above)

Problem solved, no code reuqired