LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Excel 97 - Excel 2003 Macros


You have checked the header/footer and top/bottom margin settings
to see if they are the same?

Are you absolutely sure that the row height for ALL rows is set to a specific size?
Setting all the rows to the "StandardHeight" will not guarantee cross version compatibility.
If the default font size in XL97 is different than that in XL2003 then the
default (standard) row height is probably different.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Robert Gile"
wrote in message
Assume you are talking about the size of a printed page...

Yes in print preview, 3 rows are moved to the next page making 8 total pages
rather than 6
Does everyone use the same printer?

Yes, you tried changing the printer to another brand/type, even a PDF
printer, no change
Does everyone use the same printer driver/version?

Yes, all pull from the server
Does everyone use the same font, font size and row height?

Yes, this all in the macros
Does everyone use the same monitor with identical settings?

No, I have some on 24", 19 and 20" LCDs and one on CRT. The CRT user and
another LCD user are working. But screen resolution shouldn't affect this,
right? I means its more pointing to a size calculation difference.

When I hold the correct and incorrect printouts side by side, the incorrect
page's cells appear to be larger, even though this is set in the macros. Also
note that all users on Excel 2003, same patch level [WSUS every night] and
that when I install Excel 97, the spreadsheets preveiw correctly on a
computer that previews them incorrectly in Excel 2003.
 
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
EXCEL macros running much more slowly in EXCEL 2007 vs. 2003 Eric Grove New Users to Excel 1 January 14th 10 08:17 PM
How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 Scott Sornberger New Users to Excel 2 March 19th 08 11:42 AM
Excel 2003 Workbooks with macros (.xls) converted to Excel 2007 Barb Reinhardt Excel Discussion (Misc queries) 6 September 1st 07 06:58 AM
Macros running slow on Excel 2003 but not on Excel 2002 James Excel Programming 6 April 24th 06 02:37 AM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM


All times are GMT +1. The time now is 01:15 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"