Prevent printing without hiding a sheet

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Is it possible to have a sheet in a multi-sheet workbook
accessible to users, but which does not print? The sheet
in question collects and formats the data from other
sheets in a way that can be cut and pasted into Word. It
needs to be accessible, but doesn't need to be printed at
all. The best I've managed so far is to reduce the print
area to one cell, but I can't seem to reduce it to no
cells! (p.s. for convenience the users are instructed to
print entire workbook, there are many sheets)

Many thanks,
Geoff.
 
You could try a before print macro however if the user sets the security to
high or does not
enable macros when he/she opens the workbook then it won't be of any use.
I'd suggest you
use other means to prevent this..
 
<(p.s. for convenience the users are instructed to
print entire workbook, there are many sheets)>

How are they instructed to accomplish this ?
Don't they have to go into <File> <Print>,
And check "EntireWorkbook" in order to override the default "ActiveSheet"
choice ?

Couldn't they just select the sheet tabs and *not* include this "collection"
sheet ?

This could be easily accomplished if the "collection" sheet was at either
end of the WB, where a click on the first tab to be printed, followed by a
<Shift> click on the last tab will quickly set the print boundaries.

Then, a simple click of the print icon will complete the action without
having to go into <File> <Print> to change the default print selection.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Is it possible to have a sheet in a multi-sheet workbook
accessible to users, but which does not print? The sheet
in question collects and formats the data from other
sheets in a way that can be cut and pasted into Word. It
needs to be accessible, but doesn't need to be printed at
all. The best I've managed so far is to reduce the print
area to one cell, but I can't seem to reduce it to no
cells! (p.s. for convenience the users are instructed to
print entire workbook, there are many sheets)

Many thanks,
Geoff.
 
(p.s. for convenience the users are instructed to
print entire workbook, there are many sheets)
Click to expand...

Why not create a macro that only prints the desired sheets? You could even
assign it to a button on the toolbar.
 
Back
Top