Thanks,

the problem number one solved. If I change the UserForms ShowModa
property to false, will it be visible after I close the print preview?

Another question, how can I make macro to wait until the print- o
close -button are pressed on the excel's print preview

--
Wilb
-----------------------------------------------------------------------
Wilbo's Profile: http://www.excelforum.com/member.php...fo&userid=1008
View this thread: http://www.excelforum.com/showthread.php?threadid=26947