| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Array for hidden sheets using VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I apply the same print settings to all sheets in a workbk | Excel Discussion (Misc queries) | |||
| I can not print jpeg pics. inserted in my excell sheets. | Excel Discussion (Misc queries) | |||
| Need to input data in excel that will print to pre printed sheets | Setting up and Configuration of Excel | |||
| Set up a single page to print a chronolgy of sheets printed | Excel Discussion (Misc queries) | |||
| Having trouble printing selected sheets in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
