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