Solved: Print Preview and forms

[ProteanBeing]

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]

unload the form before the preview...

[ProteanBeing]

OK... How do I get the form back after I close the print preview?

[rory]

Try something like:
Me.Hide
Sheets(1).PrintPreview
Me.Show

[ProteanBeing]

That worked! Thanks rory!