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

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Print Active Sheet(s) with Code? (2000-SR1)

    Author
    Topic
    #376216

    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?)

    Viewing 0 reply threads
    Author
    Replies
    • #615264

      Does this do what you want?

      ActiveWindow.SelectedSheets.PrintOut Copies:=1

      • #615502

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

    Viewing 0 reply threads
    Reply To: Print Active Sheet(s) with Code? (2000-SR1)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: