Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
page setup chaged when I used different computer
I had cutomized page margin setting and when I opened the file in a different
computer the page margin setting has been changed...probably what was default on the latter computer. For example, the the spreadsheet was fit all in one page and on the second computer the last row goes to the second page.... How do I keep the same page setting when I use different computer? or what am I doing wrong? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
page setup chaged when I used different computer
To ensure that a particular worksheet always fits on once page, you could put
a macro on that worksheet such as... Private Sub Worksheet_Activate() With ActiveSheet.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 End With End Sub -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "annoni" wrote: I had cutomized page margin setting and when I opened the file in a different computer the page margin setting has been changed...probably what was default on the latter computer. For example, the the spreadsheet was fit all in one page and on the second computer the last row goes to the second page.... How do I keep the same page setting when I use different computer? or what am I doing wrong? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are the "page setup" layout settings overwritten by page preview adjustments ? | Excel Discussion (Misc queries) | |||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
Page Breaks change with different computer | Excel Discussion (Misc queries) | |||
Opening an excel file on another computer changes the setup on fil | Excel Discussion (Misc queries) |