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.

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.