You could add a Workbook _Open event procedure that will set the
visibility of that worksheet to true.
Private Sub Workbook_Open()
Sheets("Put Worksheet Name Here").Visible = True
End Sub
Or you could set the visibility of the worksheet before saving and
closing.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("Put Worksheet Name Here").Visible = True
End Sub
Either method should give you the results you are after.
HTH
--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile:
http://www.excelforum.com/member.php...o&userid=18807
View this thread:
http://www.excelforum.com/showthread...hreadid=380706