Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
After installing Office XP SP3, Excel ActiveX controls are moved a | Excel Discussion (Misc queries) | |||
ActiveX Controls Display Issue? | Excel Discussion (Misc queries) | |||
Linked Cell Property In Activex controls | Excel Discussion (Misc queries) | |||
ActiveX Controls moving upon print/printpreview | Excel Discussion (Misc queries) | |||
controls look strange after install of 2003 | Excel Discussion (Misc queries) |