print excell book in a single command

March 7, 2012 at 20:53:04
Specs: Windows XP
how to print entire workbook in a single command

See More: print excell book in a single command

March 8, 2012 at 17:51:24
Well, it's not a "single command" but if you select all of the sheets and click print it will print all of the sheets.

Click the first sheet, Shift-Click the last sheet, Click print.

If you really want it done with a "single command" you'll need a macro that will either need to be stored with the workbook (making it available for that workbook only) or in a file named personal.xlsb in your xlstart folder which will make the macro available in all workbooks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question