ActiveX shifting

[dcoledc]

How do I prevent my ActiveX controls from shifting when I scroll up and down?

 

[Jaafar Tribak]

How do I prevent my ActiveX controls from shifting when I scroll up and down?

ActiveX controls are embeeded in the worksheet so they scroll along with the worksheet. You could certainly code the scrolling of the worksheet and dynamically adjust the placement of the embeeded controls but the results are shaky at best . An easy alternative is to use controls on a floating toolbar or on a modeless userform.

 

[dcoledc]

Thanks for the feedback. Sounds like more work than it is worth.