VBA to print all

[Jayadev Sarangi]

Hello, Please advise me on VBA to print all active sheets in a excel file


Regards

Jay

 

[Luke M]

To print workbook, it's just

ActiveWorkbook.PrintOut

If you only need visible sheets:

[pre]Sub PrintVisibleSheets()
For Each ws In ActiveWorkbook.Worksheets
If ws.Visible Then
ws.PrintOut
End If
Next
End Sub

[/pre]

 

[Debraj]

Hi Jaydev!


Can you please search in the top right Google Search Box,

Only "Hui Print Macro" enough to search the best Printing Solution of all Time..


Regards,

Deb

 

[Jayadev Sarangi]

Thanks all, it helped