Hi,

I fail to see the point of your question:

If no macro can be run whilst in preview mode, why would
you need an event to detect that state?

I cannot open (or activate) the VBE when a workbook is in
preview mode.

I know only one way to provoke a macro to run whilst in
print Preview, which is by using the SetTimer API.

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
hi there!!! i am working on a project that i need to know
if the user
has hit the print preview button to print preview a page.

the main idea is this. the user is asked to write
something and then
print preview the worksheet he has made the change and
LEAVE THE ACTIVE
WINDOW IN THE PRINT PREVIEW MODE.


as you know when the active window is in the print
preview mode nothing
runs behind-in the vba editor. i mean if you change back
to the vba
editor while in print preview mode and hit the f5 button
it will
freeze.

what i am thinking is this: there must be an event(hope
so) that we can
check if the user has hit the print preview button.

then capture the event and if the user has hit the
preview buttonh gets
a correct answer otherwise he fails.

this is a workaround. i do not know how to capture that
event or if VB
gives me access to these events programatically.

please help



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.