Hide worksheets on start
 

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

Hide worksheets on start
 

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

Hide worksheets on start
 

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

Hide worksheets on start
 

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