Detect Print Preview

[e-me]

Hello,

How can we detect what happens on before_print event? That's to say how can we distinguish print preview call from printing call, please?

Thanks in advance.

[raypayette]

You could place this code in the ThisWorkbook module:

Please Login or Register  to view this content.

This would center the data and would be different from the original page.

[e-me]

Thanks I'm going to try this piece of code.