Hide worksheets on start

  • Thread starter Thread starter Derek
  • Start date Start date
D

Derek

When the user opens the workbook a userform is displayed.
Is it possible to have the userform displayed without the
worksheets in the background? When the user hits the <OK>
button, then the worksheets would be displayed as
appropriate. Thanks in advance...
 
You have to have at least one unhidden worksheet.
Richard Choate

When the user opens the workbook a userform is displayed.
Is it possible to have the userform displayed without the
worksheets in the background? When the user hits the <OK>
button, then the worksheets would be displayed as
appropriate. Thanks in advance...
 
Derek,

You can't hide all of the sheets as Excel insists on one being visible. You
could minimize the workbook though
ActiveWindow.WindowState = xlMinimized
and then show the userform. You would need to normalise it when you shut the
form down.
 
Derek,

Tom Ogilvy posted this yesterday in response to a different question

Private Sub workbook_open()
ThisWorkbook.Windows(1).Visible = False
start_screen.Show
ThisWorkbook.Windows(1).Visible = True
End Sub

Dan E
 
Back
Top