printing worksheets in VBA

[bvraju12]

Hello:

I am a new user to VB and trying to work on one VBA and having some problem in printing worksheets.

In my application, I have total 7 worksheets.I have set the individual sheets for printing but I want to print all the worksheets(7) at a time with a single button click. So it would be great if anybody can give me a code to get this done.

Do I need to set the active printer for printing all this stuff.

Thanks in advance

Raj

 

[Chattin]

This is what the macro recorder gave me - modify to suit

Sub PrintWorkbook()
ActiveWorkbook.PrintOut copies:=1, Collate:=True
End Sub

HTH

 

[huggyboy]

I had a similar problem which I solved with
Worksheets(Array("Sheet1", "Sheet2", "Sheet3&quot).PrintOut

All the commands are covered in excel help (or even pressing F1 when on it)... I think thats what you want