+ Reply to Thread
Results 1 to 3 of 3

page setup in vba so that the workbook prints the same everywhere.

  1. #1
    Registered User
    Join Date
    03-14-2009
    Location
    kerala, india
    MS-Off Ver
    Excel 2003
    Posts
    20

    Arrow page setup in vba so that the workbook prints the same everywhere.

    I have a workbook which I always want to print the following way:
    Pagesize = A3
    Orientation = Landscape
    Margins 0.75 on all sides
    Page fitting = Fit to one page tall by one page wide.
    But when I take this workbook with the given settings to another computer, these settings appear as changed. I have to do everything once again. Is there a way to do this in vba so that the pages print the same everywhere?

  2. #2
    Registered User
    Join Date
    02-19-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003 and Excel 2007
    Posts
    37

    Re: page setup in vba so that the workbook prints the same everywhere.

    Try recording a macro of you making the changes and see how you get on.

  3. #3
    Registered User
    Join Date
    03-14-2009
    Location
    kerala, india
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: page setup in vba so that the workbook prints the same everywhere.

    I don't have an A3 size printer set up on my computer. so if I give xlA3 as page size, it causes an error. This workbook goes somewhere else to get printed. That's why I am asking. Help me out, please.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1