more help on using buttons and Macros?

  • Thread starter Thread starter Matt
  • Start date Start date
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?
 
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
 
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
 
Back
Top