BLOCK others from PRINTING a Wrksht or WrkBk

T

tnw

We are having certain Excel Files (Wrkbks) displayed via our Intra-Net (Inter-ofc webpg). Problem is, I don't want some of this stuff to be "printable". Purely for display & individual access to the file for info purposes. Is there such a way to Block others from printing selective wrkshts/wrkbks, but still be able to see the info from this file?
Mahalo!
 
R

Robert Rosenberg

Nope. If you show it they can print it. There may be a way of disabling the
print function when your web page displays but I'm not an expert in html
programming/security.

However, you can:

1. Hide columns/rows containing sensitive information you don't want them to
see, then use the
Tools-->Protection-->Protect Sheet command (assigning a password) to preven
them from unhiding the data.

2. Hide formulas by selecting them and enabling the Hidden option on the
Protection tab of the Format-->Cells command. Once enabled, protect the
sheet again using
Tools-->Protection-->Protect Sheet command (assigning a password).

3. You can hide entire sheets containing sensitive data using the
Format-->Sheet-->Hide command, then using the Tools-->Protection-->Protect
Workbook command (and assigning a password).
--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


tnw said:
We are having certain Excel Files (Wrkbks) displayed via our Intra-Net
Click to expand...
(Inter-ofc webpg). Problem is, I don't want some of this stuff to be
"printable". Purely for display & individual access to the file for info
purposes. Is there such a way to Block others from printing selective
wrkshts/wrkbks, but still be able to see the info from this file?
 
D

Dave Peterson

Just to add to Robert's message.

Both the worksheet and workbook protection in excel is not very strong. If you
don't want people seeing it, don't put it in excel. There's code posted here
every day/week that would unprotect the worksheet/workbook.
 
Top