2007: Disable printing but still able to view Print Preview

[Aaron]

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]

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.

 

[Homey]

Also no way to stop print button in preview i think

|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