Also no way to stop print button in preview i think

"Dave Peterson" wrote in message
...
|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