want form to open without seeing worksheet
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
|