Capturing Print and Print Preview events
 

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.

Capturing Print and Print Preview events
 

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.

--
Regards,
Tom Ogilvy


"Jignesh Bhakta" wrote in message
...
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.