Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Footer | Excel Discussion (Misc queries) | |||
custom footer | Excel Discussion (Misc queries) | |||
Custom Footer | Excel Discussion (Misc queries) | |||
Custom Footer | Excel Discussion (Misc queries) | |||
Custom footer | New Users to Excel |