Printing more than one worksheet with a single command

[VDS]

Dear All,

I have a file containing 7-8 worksheets. All the settings, formating is done. Is it possible to print all the pages with the help of any macro ?


VDS

 

[Hui]

Yes
Using the mouse Select the first sheets tab
Hold Shift and Select the last sheets tab
Ctrl P
Print

There is No Print All command that I am aware of.

 

[NARAYANK991]

Hi Santhosh ,

To add to what Hui has posted , see the following links :

http://www.exceldigest.com/myblog/2008/11/08/how-to-print-all-sheets-in-a-workbook/

http://www.exceldigest.com/myblog/2008/11/04/how-to-print-more-than-one-sheet-in-a-workbook/

Narayan

 

[VDS]

@Narayan Sir/ Hui,

The answers is excellent and how simple. Thank you so much

VDS

 

[Hui]

I read it as without macro, but if it is with Macro also read these two:
http://chandoo.org/wp/2011/09/14/hui’s-excel-report-printer/
http://forum.chandoo.org/threads/print-macro-for-selected-sheets-from-200-worksheets.5795/

 

[Deepak]

How about this

ThisWorkbook.PrintOut

 

[Deepak]

Yes
Using the mouse Select the first sheets tab
Hold Shift and Select the last sheets tab
Ctrl P
Print

There is No Print All command that I am aware of.

Have a look Pls @ http://goo.gl/0qHlu3

 

[Hui]

How about this

ThisWorkbook.PrintOut

ThisWorkbook.PrintOut prints the entire workbook by default
It can be used with some VBA to select selective pages

 

[VDS]

@ Dear All,

Thanks one again for your support


VDS