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/