Print Event

jjpkraft · Feb 27th, 2002, 10:33 AM

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 · Feb 27th, 2002, 10:37 AM

First, take a look at this:

http://www.mrexcel.com/board/viewtop...ic=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 · Feb 27th, 2002, 10:39 AM

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

jjpkraft · Feb 27th, 2002, 10:54 AM

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.

Feb 27th, 2002, 10:37 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	First, take a look at this: http://www.mrexcel.com/board/viewtop...ic=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 __________________ Regards, Juan Pablo González http://www.juanpg.com

Feb 27th, 2002, 10:39 AM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Also, I don't think this works in Excel 97. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 10:33 AM	#1
jjpkraft New Member Join Date: Feb 2002 Location: Kitchener, Canada Posts: 32	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?

Feb 27th, 2002, 10:54 AM	#4
jjpkraft New Member Join Date: Feb 2002 Location: Kitchener, Canada Posts: 32	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.