Anchoring Activex Controls
 

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?

Maybe...

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

(there's a workaround in that KB article)

KG wrote:

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

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!!!

"Dave Peterson" wrote:

Maybe...

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

(there's a workaround in that KB article)

KG wrote:

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