Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Printing a group of worksheets

I need to be able to print a certain group of worksheets within a workbook on
a consistent basis (actually there will be several groups). Can I set up
these groups so that I don't have to select the worksheets individually each
time I need to print?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Printing a group of worksheets

Record a macro when you
Select/group the worksheets to print
print the sheets
ungroup the sheets

Record as many as you need. Give the macros nice names so that you can
distinguish between them.

Pat Adams wrote:

I need to be able to print a certain group of worksheets within a workbook on
a consistent basis (actually there will be several groups). Can I set up
these groups so that I don't have to select the worksheets individually each
time I need to print?


--

Dave Peterson
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
Printing a group that is not grouped jerminski73 Excel Discussion (Misc queries) 2 May 22nd 07 07:38 PM
Printing spreadsheets with values entered (group) jerminski73 Excel Discussion (Misc queries) 0 April 26th 07 07:40 PM
I wish to group my worksheets under group tabs CSI Excel Worksheet Functions 5 October 19th 06 09:25 PM
printing group of charts tony Charts and Charting in Excel 1 September 4th 06 11:27 PM
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee jaking Excel Worksheet Functions 2 August 30th 05 02:09 PM


All times are GMT +1. The time now is 03:18 PM.

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

About Us

"It's about Microsoft Excel"