ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ActiveX Controls loose left position after printing/preview (https://www.excelbanter.com/excel-programming/312278-activex-controls-loose-left-position-after-printing-preview.html)

Sixta Zerlauth[_2_]

ActiveX Controls loose left position after printing/preview
 
Hi,

I use MS Office XP SP3 on MS Win2K.

I have Excel worksheets with activex controls with free defined
positions on the page (i.e. not linked to a cell).

When I print the page or when I use "page preview" all activex controls
are shifted to the left side of the page (i.e. the left position is set
to 0). The top position and the height of the activex controls are
unchanged.

This effect is reproducible with various printer drivers.

When I use MS Office 2003 I cannot reproduce this effect.

Has anyone an idea what is going wrong with Office XP?

Kind regards,
Sixta Zerlauth



Ron de Bruin

ActiveX Controls loose left position after printing/preview
 
Hi Sixta

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sixta Zerlauth" wrote in message ...
Hi,

I use MS Office XP SP3 on MS Win2K.

I have Excel worksheets with activex controls with free defined
positions on the page (i.e. not linked to a cell).

When I print the page or when I use "page preview" all activex controls
are shifted to the left side of the page (i.e. the left position is set
to 0). The top position and the height of the activex controls are
unchanged.

This effect is reproducible with various printer drivers.

When I use MS Office 2003 I cannot reproduce this effect.

Has anyone an idea what is going wrong with Office XP?

Kind regards,
Sixta Zerlauth





Sixta Zerlauth[_2_]

Thank a lot!
 
Ron de Bruin wrote:

Hi Sixta

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


Thanks a lot!
Sixta

Myrna Larson

ActiveX Controls loose left position after printing/preview
 
This is a bug introduced in SP3. To fix it, as the article says, you must
change the properties to Move and Size with Cells (instead of Move but don't
size).

On Sun, 3 Oct 2004 10:51:17 +0200, "Sixta Zerlauth"
wrote:

Hi,

I use MS Office XP SP3 on MS Win2K.

I have Excel worksheets with activex controls with free defined
positions on the page (i.e. not linked to a cell).

When I print the page or when I use "page preview" all activex controls
are shifted to the left side of the page (i.e. the left position is set
to 0). The top position and the height of the activex controls are
unchanged.

This effect is reproducible with various printer drivers.

When I use MS Office 2003 I cannot reproduce this effect.

Has anyone an idea what is going wrong with Office XP?

Kind regards,
Sixta Zerlauth




All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com