Hide worksheets on start

[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...

 

[Richard Choate]

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...

 

[Bob Phillips]

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.

 

[Dan E]

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