Welcome Sheet?

  • Thread starter Thread starter Stu
  • Start date Start date
S

Stu

Hello,
I need a sheet to be in a workbook and it will be a sort of welcome screen,
what I want this sheet to do is be visible on open but NOT a tab on the
bottom(where it says sheet 1, sheet 2, etc...). Is this possible, if so ...
How?

Thanks
 
Stu, Here is one way, using something like this, put this in your worksheet
code

Private Sub Worksheet_Deactivate()
Sheet1.Visible = xlSheetVeryHidden
End Sub

And this in the this workbook code

Private Sub Workbook_Open()
Sheet1.Visible = xlSheetVisible
Sheet1.Select
End Sub

You could also use a userform as a welcome screen

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
I don't seem to get on well with user forms. I just can't figure them out.

--
Thanks,
Stu


Paul B said:
Stu, Here is one way, using something like this, put this in your worksheet
code

Private Sub Worksheet_Deactivate()
Sheet1.Visible = xlSheetVeryHidden
End Sub

And this in the this workbook code

Private Sub Workbook_Open()
Sheet1.Visible = xlSheetVisible
Sheet1.Select
End Sub

You could also use a userform as a welcome screen

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
Click to expand...
 
Back
Top