Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 863
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loose formatting when printing more than one sheet rakaca Excel Discussion (Misc queries) 1 August 21st 09 02:58 AM
ActiveX controls Luke Excel Discussion (Misc queries) 1 October 26th 06 02:00 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
ActiveX controls rearranged automatically after printing Sixta Zerlauth Excel Programming 2 May 14th 04 04:41 AM
ActiveX Controls David Fixemer Excel Programming 4 February 16th 04 05:20 PM


All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"