Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Eugene, Oregon, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Active Sheet(s) with Code? (2000-SR1)

    Does Excel VBA offer a means to issue a command equivalent to the Print "Active Sheet(s)" option on the print dialog box? (Or perhaps, how do you determine which one or several sheets are currently selected so as to issue a print command on each relevant worksheet?)

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Print Active Sheet(s) with Code? (2000-SR1)

    Does this do what you want?

    ActiveWindow.SelectedSheets.PrintOut Copies:=1
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Eugene, Oregon, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Active Sheet(s) with Code? (2000-SR1)

    Thanks John. I usually work in Word VBA--didn't even occur me to look at the activewindow! Thanks again.

Posting Permissions

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