Can you make an Excel Worksheet unprintable

[Guest]

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?

 

[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.

 

[Guest]

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.

Thanks, Dave!