VBA and Printing

Hi,

I am trying to get Excel to validate before printing a worksheet.

When I hit print, I want it to check cell H8... If its value is 0 it can print.

If it is not 0 (>0) I want a prompt to say "Hey!!! It ain't 0" or words to that effect, with the option to print anyway, or cancel print.

Any idea...

I have _beforeprint (cancel as blah blah blah) but I have no idea what to put where when or how.

Thanks!!!

In the BeforePrint procedure, try this:

dim CheckH8 as integer

If H8 = 0 then
"print command"
Else
CheckH8 = msgbox("Hey!!! It ain't 0", vbOKCancel,"Put caption of msgbox here")
End If


You might have to put it in the On Print procedure if it doesn't work there.
Good luck.