mqdias
11-15-2007, 10:42 AM
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 = xlMaximizedit 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!!
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 = xlMaximizedit 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!!