Anchoring Activex Controls

[Guest]

My Activex controls (spinners and a scroll bar) move to a different location
on the worksheet each time I do Print Preview and if I change the page
orientation. Is there a property that locks them in place?

 

[Dave Peterson]

Maybe...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

(there's a workaround in that KB article)

 

[Guest]

For the benefit for anyone who may be interested, the workaround suggested by
MS is to (a) right-click each control (b) select Format Control and (c) under
the Properties tab, click "Move and Size with Cells."

This worked for me. Thanks!!!