Hi,

I have a UserForm with a "Print" button. when i click it opens a print preview, but, because i minimized the Excel window at workbook open, with the code:
Application.WindowState = xlMaximized
it doesn't maximize the window and therefore i can't see the 'print preview'.

Here is the code for the commandbutton:
Private Sub CommandButton8_Click()
    Module6.Time
    UserForm1.Hide
End Sub
'PRINT PREVIEW
Function Time()
    Application.OnTime Now + TimeSerial(0, 0, 0.5), "showForm"
End Function
Thanks for any help!!