Solved: Objects move after printing

[slondon]

I have an Excel worksheet with several objects such as pull down menus and scroll bars. Whenever I print or use print preview on this worksheet, the objects all move to the left hand side of the worksheet.

Has anyone every encountered this problem before?

Any help would be appreciated.

[HaHoBe]

Hi, slondon,

maybe have a look at Controls move to the left of the worksheet in Microsoft Excel 2002 (http://support.microsoft.com/kb/838910/en-us) or go to the Properties Window of the controls and change the value for Placement (should be 2) to 1.

Please mind that VBA Express features an Excel-Forum (http://www.vbaexpress.com/forum/forumdisplay.php?f=17) - for your next question concerning Excel ;) .

Ciao,
Holger

[johnske]

Thread moved to Excel help forum...

[slondon]

Thanks! I appreciate the help.:clap2:

I will remember to post in the Excel forum next time - I am still learning how this works.
Thanks again!