Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamically Scale Gantt Chart Time Scale | Charts and Charting in Excel | |||
Aspect Ratio calender | Excel Discussion (Misc queries) | |||
Screen aspect ratios changes when macro runs | Excel Programming | |||
Using VB Code to update one workbook with data from 4 diffferent workbooks. | Excel Programming | |||
AddName - issues w/ creating with reference to a diffferent workbook. | Excel Programming |