overriding the print button and File/Print

P

Pablo

Hello:

I have a model that I want to override the ability to print only one
page.

The model has 3 pages and the first page needs to be printed first
always before any of the others.

Can a macro be written that attaches to the model that only allows
printing from a custom print macro? Or, something that when the user
hits the toolbar print button (or File...Print...) the model always
prints the first page too?
 
G

GB

Yes - use this

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub

Put this in the module attached to this workbook in the VBE and it disables
printing from the print button.

You can write your own print macro, simply by getting Excel to record whilst
you go through the process that you want.

Geoff
 
Top