LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Scale and Aspect Ratios diffferent

A colleague of mine has created some macros with your respective helps, and
in their use weve found something odd arise.
And the outcome appears to depend on the version of excel under which the
file was created.
Weve got two workbooks. One came from excel 1997, and the other from excel
2007.
In reviewing all of the row heights, and column widths, both worksheets are
identical.
In reviewing the page set up scaling, alignment, headers/footers, margins,
etc€¦, both sheets are identical.
In every way that we can readily identify, both worksheets are identical.

However€¦..
In selecting a €śview side by side,€ť as well as when we print them out, they
have what appears to be a zoom scale difference€”even though the zoom for both
is set at 70%.
Weve found that with both the screen view, and the print out, when set to
compare their view, the row heights, and column widths do not align, as one
would expect. At the bottom, and at right, by as much as Âľ€ť.
Weve been looking on the newsgroup, as well as using Chips €śGoogle Search€ť
tool, and cannot find anything thatd explain this discrepancy, or how to
rectify it.
By and large this appears to be mostly an aesthetic issue more than a core
issue. However, as our documents are accessible for the public, we really
want to have as common appearing a form as possible.

Anything one can offer to explain what's occuring will be much appreciated.
.. .







 
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
Dynamically Scale Gantt Chart Time Scale Andrew Lavinsky Charts and Charting in Excel 2 January 31st 10 12:51 PM
Aspect Ratio calender Joel Excel Discussion (Misc queries) 0 December 1st 09 11:55 AM
Screen aspect ratios changes when macro runs owlnevada Excel Programming 2 August 4th 09 01:25 AM
Using VB Code to update one workbook with data from 4 diffferent workbooks. [email protected] Excel Programming 1 January 2nd 07 09:03 PM
AddName - issues w/ creating with reference to a diffferent workbook. Mark J Kubicki Excel Programming 3 January 15th 05 11:05 PM


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