custom footer
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 |
custom footer
Hi Tim,
Here is a google which may be what you want. http://groups.google.com/groups?hl=z...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. |
custom footer
Thanks
I have tried your suggestion. Is there a way of displaying the Print dialog box when using wb.Printout. Tim ""Peter Huang"" wrote in message ... Hi Tim, Here is a google which may be what you want. http://groups.google.com/groups?hl=z...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. |
custom footer
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 |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com