Results 1 to 3 of 3

Thread: Macro to set print default to 1 copy
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2006
    Posts
    5,334
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Macro to set print default to 1 copy

    I would like a macro to set the print default to 1 on the active sheet


    If for eg. a user changes the print setting to print to 2 or more copies, I would like a macro to set this back to 1 after printing



    your assistance in this regard is most appreciated

  2. #2
    Board Regular
    Join Date
    Jun 2006
    Posts
    5,334
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to set print default to 1 copy

    Found this code on the Net, but does not reset print copies to 1 in print preview

    Code:
     Private Sub Workbook_BeforePrint(Cancel As Boolean)
    
    Cancel = True
    
    End Sub

    It would be appreciated if someone can amend this

  3. #3
    Board Regular
    Join Date
    Jun 2006
    Posts
    5,334
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to set print default to 1 copy


Some videos you may like

User Tag List

Tags for this Thread

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
  •