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

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


"Matt" wrote:

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

Yes. You can trap this in the Workbook_BeforePrint event.

HTH. Best wishes Harald


"Matt" wrote in message
...
is there a way to prevenbt printing of a sheet if certain cells are not
filled in when they hit the button to print?