Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print workbook tabs based on a selection list
I am wondering if it is possible to create a print macro that will only print
the worksheets associated to a list of worksheets in a single workbook. In this workbook there is a worksheet tab that allows the user to make selections for the different worksheets they need to print and I would like to be able to use the selection as criteria on which worksheets to print from a single macro button. Is this possible in Excel? -- Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print workbook tabs based on a selection list
Try the below macro. I understand you are selecting the list of sheetnames//
Sub Macro() Dim varCell As Range, varRange As Range Set varRange = Selection Application.DisplayAlerts = False For Each varCell In varRange If Trim(varCell.Text) < "" Then Sheets(varCell.Text).PrintOut Copies:=1, Collate:=True End If Next Application.DisplayAlerts = True End Sub If this post helps click Yes --------------- Jacob Skaria "Cpinto" wrote: I am wondering if it is possible to create a print macro that will only print the worksheets associated to a list of worksheets in a single workbook. In this workbook there is a worksheet tab that allows the user to make selections for the different worksheets they need to print and I would like to be able to use the selection as criteria on which worksheets to print from a single macro button. Is this possible in Excel? -- Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print a selection based on checked checkboxes | Excel Worksheet Functions | |||
Print each drop-down list selection | Excel Discussion (Misc queries) | |||
How do I print out a list of the tabs in an Excel workbook? | Excel Discussion (Misc queries) | |||
Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |