password for each sheet

[lezawang]

Hi
I want to create an excel file which will be shared by different users. This file has several sheets called user1, user2, user3, etc

can I give each sheet a different password, so the user associated with that sheet can only open his/her?

thank you very much.

 

[Fluff]

Short answer: Yes

 

[mumps]

You would need a sheet that contains the sheet names in column A and their corresponding passwords in column B. When a user opens the file, all sheets would be hidden except for one blank sheet or a "Welcome" sheet with no data and the user would be prompted to enter a password in order to make that sheet visible. Would this work for you?

 

[lezawang]

Yes for sure, is that VBA? thank you so much.

You would need a sheet that contains the sheet names in column A and their corresponding passwords in column B. When a user opens the file, all sheets would be hidden except for one blank sheet or a "Welcome" sheet with no data and the user would be prompted to enter a password in order to make that sheet visible. Would this work for you?

 

[Fluff]

Maybe

Private Sub Workbook_Open()
   Dim Ws As Worksheet
   Dim Pword As String
   
   For Each Ws In Sheets(Array("User1", "User2", "User3"))
      Ws.Visible = xlSheetVeryHidden
   Next Ws
   Pword = InputBox("Please enter password")
   Select Case Pword
      Case "User1"
         Sheets("User1").Visible = True
      Case "User2"
         Sheets("User2").Visible = True
      Case "User3"
         Sheets("User3").Visible = True
   End Select
End Sub

Change sheets names & passwords to suit

 

[lezawang]

Thank you so much. I appreciate your help.

 

[Fluff]

You're welcome & thanks for the feedback