Resize textbox to show all text during print in excel?

[ceyhorn]

I have an excel file with a few textbox's on it. They text boxes have autowrap and vertical scrollbars. When I do a print preview the textbox only shows a few lines of text. Is there a way to show all the text in the textbox when doing a print? The autoresize property just covers up the rest of the sheet.

thank in advance,

Chris

 

[ceyhorn]

Any ideas?