coliervile
02-25-2008, 06:41 AM
Good morning everyone. When I run the following macro the worksheet "Printout" displays and then when it closes the macro is suppose to display the worksheet "Dashboard" and then show the userform "frmRequest". The macro seems like it doesn't have time to display the "Dashboard" before the userform loads. The userform loads up and if you close the userform then the worksheet "Dashboard" fully dispalys. Is there a reason this is happening and how do you fix it? By the way the "Dashboard" is not hidden.
Best regards,
Charlie
Private Sub CommandButton3_Click()
Application.ScreenUpdating = False
Unload frmRequest
Sheets("Printout").Visible = True
Sheets("Printout").Select
ActiveWindow.SelectedSheets.PrintPreview
Sheets("Printout").Visible = False
Sheets("Dashboard").Select
frmRequest.Show
Application.ScreenUpdating = False
End Sub
Best regards,
Charlie
Private Sub CommandButton3_Click()
Application.ScreenUpdating = False
Unload frmRequest
Sheets("Printout").Visible = True
Sheets("Printout").Select
ActiveWindow.SelectedSheets.PrintPreview
Sheets("Printout").Visible = False
Sheets("Dashboard").Select
frmRequest.Show
Application.ScreenUpdating = False
End Sub