Good evening raw

The print preview window is a completely different kettle of fish to
the normal worksheet view window I'm afraid, and as such is completely
incompatible with userforms.

There is a way around it, and that it is to close the userform before
the print preview command is invoked. Once you call the print preview
window, control of the macro appears to be lost as Excel moves out of
its normal environment, and as such your macro would have to terminate
as the print preciew command is executed.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=479967