more help on using buttons and Macros?

M

Matt

is there a way to prevenbt printing of a sheet if certain cells are not
filled in when they hit the button to print?
 
B

BobT

You simply need to write a macro for the BeforePrint action:

Private Sub Workbook_BeforePrint(Cancel As Boolean)

<do your test, etc. here>

End Sub
 
H

Harald Staff

Yes. You can trap this in the Workbook_BeforePrint event.

HTH. Best wishes Harald
 
Top