Print Array for hidden sheets using VBA

[Guest]

Is it possible to print multiple hidden sheets using the array function in
VBA? Currently my code opens them all up, prints, then closes them. However
this is quite slow and I don't really need, or want, to see the sheets.
Something like...

With Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", _
"Sheet5", "Sheet6", "Sheet7"))
.PrintOut Copies:=1
End With

Thanks in advance

 

[Michael Koerner]

Sounds more like an Excel request than a PowerPoint one.

--
<>Please post all follow-up questions/replies to the newsgroup<>
<><>Email unless specifically requested will not be opened<><>
<><><>Do Provide The Version Of PowerPoint You Are Using<><><>
<><><>Do Not Post Attachments In This Newsgroup<><><>
Michael Koerner [MS PPT MVP]


| Is it possible to print multiple hidden sheets using the array function in
| VBA? Currently my code opens them all up, prints, then closes them.
However
| this is quite slow and I don't really need, or want, to see the sheets.
| Something like...
|
| With Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", _
| "Sheet5", "Sheet6", "Sheet7"))
| .PrintOut Copies:=1
| End With
|
| Thanks in advance

 

[Guest]

You're absolutely right! Just as I hit send I realised it was heading to
Powerpoint not Excel questions and it was too late - my mistake!

 

[Michael Koerner]

Not a problem, I do that quite often and attribute it to old age ;-o))

--
<>Please post all follow-up questions/replies to the newsgroup<>
<><>Email unless specifically requested will not be opened<><>
<><><>Do Provide The Version Of PowerPoint You Are Using<><><>
<><><>Do Not Post Attachments In This Newsgroup<><><>
Michael Koerner [MS PPT MVP]


| You're absolutely right! Just as I hit send I realised it was heading to
| Powerpoint not Excel questions and it was too late - my mistake!
|
| "Michael Koerner" wrote:
|
| > Sounds more like an Excel request than a PowerPoint one.
| >
| > --
| > <>Please post all follow-up questions/replies to the newsgroup<>
| > <><>Email unless specifically requested will not be opened<><>
| > <><><>Do Provide The Version Of PowerPoint You Are Using<><><>
| > <><><>Do Not Post Attachments In This Newsgroup<><><>
| > Michael Koerner [MS PPT MVP]
| >
| >
| > | > | Is it possible to print multiple hidden sheets using the array
function in
| > | VBA? Currently my code opens them all up, prints, then closes them.
| > However
| > | this is quite slow and I don't really need, or want, to see the
sheets.
| > | Something like...
| > |
| > | With Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", _
| > | "Sheet5", "Sheet6", "Sheet7"))
| > | .PrintOut Copies:=1
| > | End With
| > |
| > | Thanks in advance
| >
| >
| >