I don't think you can do it. The workbook event that you'd want to use is
workbook_beforeprint, but it can't tell the difference between printing and
previewing.


Aaron wrote:

Hello,

I am trying to disable all printing when a specific cell on a worksheet is
blank. Meaning there is no way a user can print anything from the worksheet
until the cell has been filled. Also, I need to be able to view the print
preview screen of the sheet....just not be able to actually print the sheet.

Any code samples or examples would be both appreciated and helpful. This
example needs to work for Excel 2007. Working for any other versions is not
mandatory but it is a bonus.

Thanks for the help in advance,
Aaron

--

Dave Peterson