PDA

View Full Version : Solved: Print Preview and forms



ProteanBeing
12-28-2007, 09:28 AM
I created a button in a userform to print preview a chart based on data in the form. The print preview comes up but so does the form and locks excel. Does anyone know why?

lucas
12-28-2007, 09:41 AM
unload the form before the preview...

ProteanBeing
12-28-2007, 09:49 AM
OK... How do I get the form back after I close the print preview?

rory
12-28-2007, 10:21 AM
Try something like:
Me.Hide
Sheets(1).PrintPreview
Me.Show

ProteanBeing
12-28-2007, 10:41 AM
That worked! Thanks rory!