View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron Aaron is offline
external usenet poster
 
Posts: 287
Default 2007: Disable printing but still able to view Print Preview

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