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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auditing functions hushed 3
Trace Dependents Type Functions Hushed 2
Help to create a macro 2
Excel VBA - Problem with Closing Print Preview 0
Macro buttons for gray scale and color print 2
How to best select from image and print full size? 1
macro to print sheet2 without open sheet2 1
Macro to print multiple purchase orders 1

Back
Top