Limit Printing of Worksheets.
 

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

Limit Printing of Worksheets.
 

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

--
Message posted from http://www.ExcelForum.com