Macro again

[Laszlo]

Hi
I would like to get a little help. I have a workbook that contains worksheet for individual use. The second sheet is a general one with all the names and information. The first one is the sheet with all the names. All names had been hyperlinked to the according sheet. What I would like to have is a macro that always opens the first sheet, when the user opens the workbook. Or have a macro, when the user opens the workbook, asking for the name, opens the sheet belongs to the user and hides the other worksheets. It is probably very easy, but for me takes a little bit longer.
Thanks in advance
Laz

 

[DRJ]

Hi

Put this in the thisworkbook code section

Private Sub Workbook_Open()
Sheets(1).Select
End Sub

To hide sheets you can use sheets("Sheet1").visible = false

 

[Smitty]

Heya Lazlo,

PM me your e-mail address and I will send you a workbook that I put together for another board member last week that does just what you're asking. (Instructions included )

Have a great weekend,

Smitty

EDIT: I can send it on Monday as I have it @ work...