If you have a workbook with a considerable number of worksheets, some visible and other hidden, and you want to print only the visible sheets, then you can use this macro:
Sub PrintVisibleSheets()
‘***************************************************
‘Print only visible sheets in the active workbook [...]
To print all worksheets in a workbook then :
1. In the File menu click Print.
2. The Print window will open.
3. At the bottom of the Print window find a section labeled: Print what .
4. Click on the radio button labeled: Entire workbook.
5. Click OK.
Applies to Excel 2003
To print more than one worksheet in a workbook then :
1. Select the worksheets you want to print.
If the sheets to be printed are adjacent then click on the first one, press SHIFT then click the last one.
If they are not then click on the first one, press CTRL then click the others one at [...]
If you have one or more heading rows in your worksheet and you want to print that worksheet then the heading row(s) will be printed on the first page only (default).
To print the heading row(s) on every page do the following:
Click File then click Page Setup .The Page Setup [...]
If you have a worksheet and you only want to print part of that worksheet then follow the steps below:
Method 1
Click File then click Page Setup .The Page Setup window will open.
Click the Sheet tab.
In [...]
