Can you make an Excel Worksheet unprintable

I

ibvalentine

I asked this question about Word on the Word newsgroup and I am guessing the
answer is the same. Does anyone know how to protect a worksheet so that it is
unprintable? Is there a non-programmable way of doing it?
 
D

Dave Peterson

Nothing built into in excel will stop a user from printing a worksheet.

And if you allowed macros to try to stop the printing, then all the user would
have to do is turn off macros--or even just copy to a different workbook.

You may be able to fool some people for just a little bit of time, by changing
the print range to a single cell (empty).

But that wouldn't stop many -- and it wouldn't stop them for long.
 
I

ibvalentine

Dave Peterson said:
Nothing built into in excel will stop a user from printing a worksheet.

And if you allowed macros to try to stop the printing, then all the user would
have to do is turn off macros--or even just copy to a different workbook.

You may be able to fool some people for just a little bit of time, by changing
the print range to a single cell (empty).

But that wouldn't stop many -- and it wouldn't stop them for long.
Click to expand...

Thanks, Dave!
 
Top