When it prints, in the macro, set the .height property of the form
sufficiently to have all the information displayed... then after the
..printform, reset the .height property

"cparsons" wrote:


I have a user form that uses scroll bars. I added a button at the
bottom of the form to print what is on the user form. The code
executed is userform.Printform. The only part of the form that prints
is the part of the form that is in the user window. How can I get the
whole form to print, including what is out of the user window?


Thanks,
Craig


--
cparsons
------------------------------------------------------------------------
cparsons's Profile: http://www.excelforum.com/member.php...o&userid=12867
View this thread: http://www.excelforum.com/showthread...hreadid=392914