Forum Discussion

Copper Contributor

Jul 11, 2023

Printing all the tabs in excel separately

Hi everyone, I'm using excel 365 version. I got the problem with my report file. The file contains multiple sheets, each sheet contains the transaction of 1 customer. When printing the report of ...

excel

office 365

HansVogelaar

MVP

Jul 11, 2023

QTr90

See if running this macro works for you:

Sub PrintSheets()
    Dim wsh As Worksheet
    For Each wsh In Worksheets
        wsh.PrintOut
    Next wsh
End Sub

QTr90

Copper Contributor

Jul 13, 2023

HansVogelaar Works perfectly.

Thank you so much!