Printing using VBA

[VbaHell]

Hello all, I am using Excel 2007 and need help please

I have a workbook which has multiple worksheets, the number of worksheets can change daily.
I am looking for some VBA code I can use to print out every worksheet in one go.
Is this possible please

 

[MARK858]

Try

Sub PrintSheets()
    Dim x As Integer
    For x = 1 To ActiveWorkbook.Worksheets.Count
        Sheets(x).PrintOut
    Next
End Sub

or even try

Sub PrintSheets2()
ThisWorkbook.PrintOut
Cancel = True
End Sub

 

[VbaHell]

Thanks Mark858, This will help me a lot

 

[MARK858]

Your welcome. I did add an edit with another obvious option as you were posting.