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
 
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
 
H

Harald Staff

Yes. You can trap this in the Workbook_BeforePrint event.

HTH. Best wishes Harald
 

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

cell protection 1
Macros Move when Printing 2
Macro buttons for gray scale and color print 2
Using Tab key to jump to specific cell 2
How to access macros via tool buttons? 2
Page not fully printing... 2
Macros in shared workbooks 4
Macros 1

Top