Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Using checkboxes to print multiple worksheets

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Using checkboxes to print multiple worksheets

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


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 12:02:02 -0800, KathyN
wrote:

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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Using checkboxes to print multiple worksheets

Kathy,

Try this: http://j-walk.com/ss/excel/tips/tip48.htm

"KathyN" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Using checkboxes to print multiple worksheets

This worked perfectly - I am using it in several workbooks and it saves so
much time. Thank you!

"aquigley" wrote:

Kathy,

Try this: http://j-walk.com/ss/excel/tips/tip48.htm

"KathyN" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I print a spreadsheet with multiple worksheets? Need Help Excel Discussion (Misc queries) 1 May 23rd 06 10:17 PM
How do I print multiple worksheets on one page? renonv Excel Discussion (Misc queries) 1 December 17th 05 03:42 PM
print multiple worksheets on one page Michelle Excel Discussion (Misc queries) 2 November 21st 05 06:25 PM
Print multiple worksheets on one page in Excel? TCTeach Excel Discussion (Misc queries) 1 May 3rd 05 05:01 AM
What is the simplest way to print multiple worksheets? substring Charts and Charting in Excel 1 April 21st 05 11:49 PM


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"