| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible?
I have several worksheets that i need to print off.
But since i can add more sheets to this workbook, i want to be able to print off all the sheets (not by name) except for about 3 sheets i can name. Currently i have a macro that specifies each sheet by name then prints 1 page from it. But as i have now added a couple of sheets to it, i need to keep adding more code to it to include the newly added sheets. My thinking is if i can have a code that will print all sheets a specified page(1) except for, say sheet1, sheet2 and sheet3. Is this possible? Corey.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible?
Dim sh as Worksheet
for each sh in Thisworkbook.Worksheets if sh.Name < "Sheet1" and sh.name _ < "Sheet2" and sh.Name < "Sheet3" then ' do something with Sh end if Next -- Regards, Tom Ogilvy "Corey" wrote in message ... I have several worksheets that i need to print off. But since i can add more sheets to this workbook, i want to be able to print off all the sheets (not by name) except for about 3 sheets i can name. Currently i have a macro that specifies each sheet by name then prints 1 page from it. But as i have now added a couple of sheets to it, i need to keep adding more code to it to include the newly added sheets. My thinking is if i can have a code that will print all sheets a specified page(1) except for, say sheet1, sheet2 and sheet3. Is this possible? Corey.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible?
Thanks Tom.
Too easy. Cheers. "Tom Ogilvy" wrote in message ... Dim sh as Worksheet for each sh in Thisworkbook.Worksheets if sh.Name < "Sheet1" and sh.name _ < "Sheet2" and sh.Name < "Sheet3" then ' do something with Sh end if Next -- Regards, Tom Ogilvy "Corey" wrote in message ... I have several worksheets that i need to print off. But since i can add more sheets to this workbook, i want to be able to print off all the sheets (not by name) except for about 3 sheets i can name. Currently i have a macro that specifies each sheet by name then prints 1 page from it. But as i have now added a couple of sheets to it, i need to keep adding more code to it to include the newly added sheets. My thinking is if i can have a code that will print all sheets a specified page(1) except for, say sheet1, sheet2 and sheet3. Is this possible? Corey.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel ignores "Sheets in new workbook" setting | Excel Discussion (Misc queries) | |||
| Set sem__ = Sheets("template").Copy(befo=Sheets(1)) | Excel Programming | |||
| "With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets | Excel Programming | |||
| Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
| Sheets("Sheet1").Move After:=Sheets(2) | Excel Programming | |||
Linear Mode
