Print Array for hidden sheets using VBA

A

Ant

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
 
M

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
 
A

Ant

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!
 
M

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
| >
| >
| >
 
Top