[Derek[_2_]]

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

"Derek" wrote in message
...
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[_5_]]

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.

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Derek" wrote in message
...
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...

[Dan E[_2_]]

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

"Derek" wrote in message
...
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...