Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: save the print settings when i use save as command

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    the print and page settings do not get saved when i use save as, what is to be done let me know asap it wud be of great help.


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What do you mean Print and Page settings ?

    The Page setup is saved at workbook level, that means, each sheet remembers it's page setup settings.

    About printing setup, do you mean, number of copies, what order, which pages, that stuff ?
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP
    Colo's Avatar
    Join Date
    Mar 2002
    Location
    Kobe, Japan
    Posts
    1,456
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default

    Hi skalavati,
    You mean page settings of printer driver?
    If so, it is not able to save.

    As my idea, Add one more same printer (for "the sheet") on control panel, and when you want to print "the sheet" , switch printer by vba.
    Hope this helps + pen pineapple apple pen!

    Masaru Kaji aka Colo - cellmasters.net

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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