Limit Printing of Worksheets.

  • Thread starter Thread starter Danny
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Excel VBA help: Text file formatting 19
macro is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activit 1
Print entire workbook with each sheet starting at page 1 8
Printing several worksheets 2
Combining Multilple Worksheets Into One 6
Print macro 2

Back
Top