Print Event

[jjpkraft]

I have a sheet that can only be printed if certain cells have been populated using the before_print event.
The problem is I want to print preview without needing to fill in all the required fields. The print event and print preview events are one in the same.
How can I run a piece of code to cancel the event of printing but not for print previewing?

 

[Juan Pablo González]

First, take a look at this:

http://www.mrexcel.com/board/viewtopic.php?topic=466&forum=2

Then, you should have a public variable that sets to True (Or False) if the Print button was pressed and the oposite if the Print Preview button was pressed.

Then, in the BeforePrint() event do something like

If MyVar = True then
'Check for populated cells
Else
'Do nothing, allow to print preview
End If

 

[Juan Pablo González]

Also, I don't think this works in Excel 97.

 

[jjpkraft]

this will allow the user to print preview. When they are in the preview screen they will be allowed to hit the print button there. This is the thing I'm trying to avoid the most.