As you said, no code runs when you are in print preview, so you can not
interact with the user while in print preview.

--
Regards,
Tom Ogilvy

"nikolaosk" wrote in message
...
hi there dag!!!


thanks a lot for your response.

my problem is slightly different.

i need to be able to run the subroutine in the VBA editor that checks
if the user is in the print preview mode when the user is actually in
teh print preview mode. not just check if he has pressed the print
preview button!!!!!


but if you try it yourself you will see that the vba editor freeezes.



for example


open a workbook. press alt-F11. write the simple sub



sub hello()

msgbox "hello"

end sub


then go back to the workbook, write something in the worksheet and then
print preview it.

then switch to the VBA editor. try to run the hello sub. nothing
works.


you see what i mean?


i appreciate any help



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