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.



ibvalentine wrote:

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