Welcome Sheet?

[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

 

[Paul B]

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

 

[Stu]

I don't seem to get on well with user forms. I just can't figure them out.

--
Thanks,
Stu

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

 

[Harald Staff]

Hi Stu

It's pretty easy, see John's page
http://j-walk.com/ss/excel/tips/tip39.htm

From there -just decorate the form and its done.