Capturing Print and Print Preview events

[Jignesh Bhakta]

Hi,

Does anyone know if there is a difference between the
Print and Print Preview events in MS Excel? I am trying
to capture Print and Print Preview but an unable to
determine whether the user has selected Print or Print
Preivew.

Thanks,

Jignesh.

 

[Tom Ogilvy]

There isn't a built in way to tell. The both trigger the beforeprint event,
but don't set any indicator that either one or the other will occur.

Someone posted a method that tested the value of some obscure builtin
dialogbox, as I recall, but I don't recall which one. If I can find it I
will post back, but I don't think it was posted to the newsgroup.