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:
it doesn't maximize the window and therefore i can't see the 'print preview'.
Application.WindowState = xlMaximized
Here is the code for the commandbutton:
Private Sub CommandButton8_Click()
Thanks for any help!!
Application.OnTime Now + TimeSerial(0, 0, 0.5), "showForm"