Print macro query

[robjowens]

Haven't bought my copy of Walkenbach/Bible into work today and google isn't turning up anything interesting... Is there a way to insert a macro that precedes the print function so that everytime a user goes 'File -> Print' my macro does it's job and the user is none the wiser?

 

[VoG]

Try in the ThisWorkbook module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
'
'your code here
'
End Sub

 

[Jon von der Heyden]

Hi

You can use the workbook's before print event. Cancel the print first, then go through all of the other configurations, and then print.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Cancel = True
    'rest of macro
End Sub

 

[robjowens]

Thanks Jon & VoG,

Jon, by using your method the sheet comes up with a message saying there's nothing to print. Do I have to turn on the print function once my macro has been inserted?

thanks,
Rob

 

[Jon von der Heyden]

Can you share with us the rest of the macro? It might not be necessary to cancel the print first. I tend to cancel, then do the configurations (.e.g page setup) and then I tell it to print at the end, usually using the PrintOut method.