Limit Printing of Worksheets.

D

Danny

Hi,

I have 14 worksheets in my workbook, say, named sheet 1 to
sheet 14.

It is possible to have a macro so the user can print ONLY
ONCE from sheet 1 to sheet 4?

Thanks
 
C

Charles

Danny,

Something like this should work.
You should also set the print area to be printed.


Sub Print_worksheet()
Worksheets("sheet1").PrintOut
Worksheets("sheet2").PrintOut
Worksheets("sheet3").PrintOut
End Sub

HTH

Charle
 
Top