View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dan E[_2_] Dan E[_2_] is offline
external usenet poster
 
Posts: 102
Default 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...