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.



Gary Brown

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.
Gary Brown

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question