hi
a workbook must contain at least 1 visible sheet so it's not possible to
hide all sheets until one is selected.
i would recomend that you select a "default start point" and open the
workbook to that point.
Private Sub Workbook_Open()
frmCaptain.Show
sheets("sheet1").activate 'pick your own
cellls(1,1).activate
End Sub

regards
FSt1

"Ruth" wrote:

Hi there

I have a file that when opened a form automatically opens. The code I used
is:


Private Sub Workbook_Open()
frmCaptain.Show
End Sub

I want it to open so the user just sees the form until they select a
worksheet from the combo box on the form. The combo box on the form is
already in place and working.


In other words, I don't want the worksheets to show when the file is opened,
just the form should show. Then the worksheet can show once selected on the
form.

Is this possible? if so, how?



--
Thank-you!
Ruth