Using checkboxes to print multiple worksheets

  • Thread starter Thread starter KathyN
  • Start date Start date
K

KathyN

I am using Excel 2003. I have a spreadsheet with several sheets. I would
like for users to be able to enter a check next to the sheets they would like
to print, then click one button to print all selected sheets. Is this
possible?

Thanks
 
CTRL + Click on the sheet tabs you want then Print Icon


Gord Dibben MS Excel MVP
 
This worked perfectly - I am using it in several workbooks and it saves so
much time. Thank you!
 
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

Excel VBA - Problem with Closing Print Preview 0
Print selected worksheets in multiple workbooks? 1
Change multiple worksheets at one time to print in color 1
A macro code to print multiple sheets in different w.books 3
Printing multiple worksheets in a workbook 3
Printing Duplex Copies in Excel 1
Advanced Printing... 1
Printing a two spreadsheets front and back 2

Back
Top