Print Preview without BeforePrint

Question

Excel 2007

I have some "BeforePrint" code that saves the workbook before printing.

I would like to be able to see a Print Preview without running the BeforePrint event code.

ie, I want the code to run before printing, not before print previewing.

Is this possible?

Thanks in advance.

Dave

Answer 1

I added your macro to a workbook. When I used PrintPreview from QAT the message box did not fire; onl;y when within Print Preview when I hit the Print button.

The QAT Print Preview icon looks like piece of paper with magnifying glass over it.

best wishes

Answer 2

Ok thanks.

Here's my code (without Dims).

Private Sub Workbook_BeforePrint(Cancel As Boolean)

msg = "The Form will be saved before being printed." & vbNewLine & vbNewLine

msg = msg & "Proceed?"

Title = "Print Form"

A = MsgBox(msg, vbYesNo, Title)

If A = vbNo Then Cancel = True: Exit Sub

Call SaveForm

End Sub

This code runs when a print preview is requested, but I don't want it to - only when an actual print is requested.

Regards - Dave.

Answer 3

Hi Vijay,

Thanks for the reply. I've tried this, but Ctrl+F2 seems to qualify as a BeforePrint event

Dave.

Then you have to provide code here, then only someone from this forum can suggest little change to the code, as I am not so good in coding :-)

Answer 4

Hi Vijay,

Thanks for the reply. I've tried this, but Ctrl+F2 seems to qualify as a BeforePrint event

Dave.

Answer 5

Just enter Ctrl+F2 (Print Preview) and it will show the print preview, once you are ok then give print command, so your code will work before printing and at the same time you are able to see the print preview.