ActiveX Controls

[maclachlan19]

I have a spreadsheet that use a couple different ActiveX Controls (Command Button). Both buttons trigger VBA scripts thru a Private Sub CommandButton1_Click()
The problem I'm having is the buttons are sometimes changing size when clicked, they either grow very big after a few clicks or they shrink really small. I've read other forums and this appears to be an Excel issue, especially when users are logging into a RDP session with different resolution monitors.

To solve this problem is it possible to trigger the VBA in a different way. Could I use a shape and assign the code. Or could I use a hyperlink that is attached to word in a cell. Or does anybody have an other idea?

Thanks

 

[Zot]

I have a spreadsheet that use a couple different ActiveX Controls (Command Button). Both buttons trigger VBA scripts thru a Private Sub CommandButton1_Click()
The problem I'm having is the buttons are sometimes changing size when clicked, they either grow very big after a few clicks or they shrink really small. I've read other forums and this appears to be an Excel issue, especially when users are logging into a RDP session with different resolution monitors.

To solve this problem is it possible to trigger the VBA in a different way. Could I use a shape and assign the code. Or could I use a hyperlink that is attached to word in a cell. Or does anybody have an other idea?

Thanks

Looks like this is related subject

ActiveX Controls Resizing Bug

Hello, I'm having issues with a spreadsheet I've created. I've added in various Active X buttons/scroll bars/checkboxes and textboxes with macros linked to some. When someone else uses the spreadsheet (it doesn't seem to happen on mine) when any of the controls are clicked strange things start...

www.mrexcel.com

 

[MARK858]

Could I use a shape and assign the code.

Don't see any reason why not. Might be easier if you just try it.
In general you should avoid ActiveX controls wherever possible.