| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select multiple sheets on a dinamic context
Hi, I've built a model in which the user is able to add new sheets and
I'd like to make a print macro that selects only certain sheets. The catch is that there are certain sheets which I don't want to print and there will be new sheets (added by the user) that should be printed... How could I do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select multiple sheets on a dinamic context
You could use an array, like so:
Sub PrintSome() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets(Array("Sheet1", "Sheet3")) ws.PrintOut Next ws End Sub James "bliten_bsas" wrote in message ps.com... Hi, I've built a model in which the user is able to add new sheets and I'd like to make a print macro that selects only certain sheets. The catch is that there are certain sheets which I don't want to print and there will be new sheets (added by the user) that should be printed... How could I do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select multiple sheets on a dinamic context
was sure surprised to run into this. Just down my alley.
useing this code I have many sheets some named others numbered. should the numbered sheets be refered to by number only? not as "sheet1" only "1". Anyway I will start and see what happens Thanks "Zone" wrote: You could use an array, like so: Sub PrintSome() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets(Array("Sheet1", "Sheet3")) ws.PrintOut Next ws End Sub James "bliten_bsas" wrote in message ps.com... Hi, I've built a model in which the user is able to add new sheets and I'd like to make a print macro that selects only certain sheets. The catch is that there are certain sheets which I don't want to print and there will be new sheets (added by the user) that should be printed... How could I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why when I select multiple sheets they are not highlighted in 07? | Excel Discussion (Misc queries) | |||
| Select Multiple Sheets from Menu | Excel Programming | |||
| Select Multiple Sheets from Menu | Excel Programming | |||
| How to select multiple sheets in VBA? | Excel Programming | |||
| Select Multiple sheets | Excel Discussion (Misc queries) | |||
Linear Mode
