Protect SharedWorkbook

[Krishnab4u]

Dear All,
I have a workbook which has to be shared between 3 to 4 people, who will update data at the same time.
but depending on the user opening the file, certain sheets to be hidden and visible.
How do i achieve the same. Kindly suggest.

Regards
Krishnamoorthy S

 

[KUYJS]

Hi,
Record macro in workbook open event
If Environ("username") = "ABCD" Then
Sheets("SheetName").Visible = xlVeryHidden"
End if

This will hide the sheet(s) and can only be made visible again through the use of VBA code. (As follows
Sheets("SheetName").Visible = True"

Hope this helps,
Tarun