Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Determine PrintJob is Finished with VBA
I would like to change the format on certain cells on a worksheet when a
user prints the worksheet. Then, after the print is complete, I would like to restore the formatting back to its original state. I can add code to the BeforePrint event to change the format, but am having problems restoring the format as there is no AfterPrint event. Does anyone have an idea or tip to use for cases like this. Thank you in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Determine PrintJob is Finished with VBA
In beforeprint
make you changes disable events issue a command to print enable evens change back ' now cancel the original print command cancel = true End beforeprint event. The disadvantage is there is no easy way to differentiate a print preview from a print command, and both fire the beforeprint event - so you would force a print when the user only wants a print preview -- Regards, Tom Ogilvy "SFatz" wrote in message ... I would like to change the format on certain cells on a worksheet when a user prints the worksheet. Then, after the print is complete, I would like to restore the formatting back to its original state. I can add code to the BeforePrint event to change the format, but am having problems restoring the format as there is no AfterPrint event. Does anyone have an idea or tip to use for cases like this. Thank you in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Determine PrintJob is Finished with VBA
Thanks a bunch Tom.
The part that I was missing was to disable the events before the printout command. Now it works as expected. Thanks again. "Tom Ogilvy" wrote in message ... In beforeprint make you changes disable events issue a command to print enable evens change back ' now cancel the original print command cancel = true End beforeprint event. The disadvantage is there is no easy way to differentiate a print preview from a print command, and both fire the beforeprint event - so you would force a print when the user only wants a print preview -- Regards, Tom Ogilvy "SFatz" wrote in message ... I would like to change the format on certain cells on a worksheet when a user prints the worksheet. Then, after the print is complete, I would like to restore the formatting back to its original state. I can add code to the BeforePrint event to change the format, but am having problems restoring the format as there is no AfterPrint event. Does anyone have an idea or tip to use for cases like this. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help: Macro Nearly Finished | Excel Discussion (Misc queries) | |||
Loop until finished | Excel Discussion (Misc queries) | |||
Loop until finished. | Excel Discussion (Misc queries) | |||
How to know if a sort is finished sucessfully? | Excel Programming |