ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Worksheet printing (https://www.excelbanter.com/excel-worksheet-functions/139618-worksheet-printing.html)

Laura

Worksheet printing
 
How can I prevent 3 tabs of a 6 tab workbook from being printed automatically
if someone clicks on print workbook - they are refernece tabs only which
shoudl never be printed.

Thanks


E Savard

Worksheet printing
 
highlight only the cells you wish to have printed, then go to the file
menuprint settingsset print area, then save your file again with those new
settings. This should set it for every time the document gets opened.

"Laura" wrote:

How can I prevent 3 tabs of a 6 tab workbook from being printed automatically
if someone clicks on print workbook - they are refernece tabs only which
shoudl never be printed.

Thanks


E Savard

Worksheet printing
 
Sorry I misread your question, to get the sheets you want to print, click on
the first sheet, then if it is the first three sheets, just hold the shift
key down and select the first 3 sheets, if the sheets are not directly beside
each other, hold down the ctrl key and choose the sheets you wish to print,
in the print preview window you can make sure you have what you want before
you print it

"Laura" wrote:

How can I prevent 3 tabs of a 6 tab workbook from being printed automatically
if someone clicks on print workbook - they are refernece tabs only which
shoudl never be printed.

Thanks



All times are GMT +1. The time now is 12:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com