View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SFatz SFatz is offline
external usenet poster
 
Posts: 3
Default 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.