custom footer

[Tim Marsden]

Hi,

If I change the print footer during the 'Before Print' event, how can I put
it back to its original state after the print has been produced.
Is there some kind of 'After Print' activity?, is one of the other events
fired, i.e. sheet activated etc.

Thanks
Tim

 

[Peter Huang]

Hi Tim,

Here is a google which may be what you want.
http://groups.google.com/groups?hl=zh-CN&lr=&c2coff=1&threadm=VA.00000068.00
427db3%40t8000&rnum=1&prev=/groups%3Fhl%3Dzh-CN%26lr%3D%26c2coff%3D1%26q%3De
xcel%2Bbeforeprint%2Bevent%2Bafter%2Bprint

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tim Marsden]

Thanks

I have tried your suggestion. Is there a way of displaying the Print dialog
box when using wb.Printout.

Tim

 

[Peter Huang]

Hi Tim

I think you may try to use the code line below for show the printer dialog.
Application.Dialogs(xlDialogPrint).Show


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no right