Password Authentication

[helplessnoobatexcel]

Hi, I'm a beginner at Excel VBA Macro coding and I know almost nothing about coding. I am tasked with creating a shared excel workbook in which users are only allowed to view & edit their respective sheets whilst I and a few others have access to view & edit all sheets. Currently, I have found a code online to do a user login and password in which it will bring the users to their designated sheets based on their login credentials. However, I am facing this error everytime I try to run this code and I have no idea how to debug it.. Thanks for your help in advance!

Link of where I got the code from: Protecting Individual Worksheets, by User (Microsoft Excel)

 

[Peter_SSs]

Instead of

Sheet1(sSName).Visible = True

it should be

Sheets(sSName).Visible = True

and similar for the others.

 

[helplessnoobatexcel]

Instead of

Sheet1(sSName).Visible = True

it should be

Sheets(sSName).Visible = True

and similar for the others.

Hi Peter,
I have just tried this method, unfortunately it doesn't work and it presents me with a new error: of runtime error '9', stating that it is out of range and it is still the same line of code that has the error. Any idea on how I can rectify this?

 

[Peter_SSs]

f runtime error '9', stating that it is out of range and it is still the same line of code that has the error.

I think that would mean that your variable sSName does not hold the name of one of your worksheets. When you get the error and click 'debug' hover over sSName and see what appears in the pop-up.

 

[helplessnoobatexcel]

I think that would mean that your variable sSName does not hold the name of one of your worksheets. When you get the error and click 'debug' hover over sSName and see what appears in the pop-up.

Hi Peter, thanks for your help! I followed your instructions and managed to rectify it. However...my code doesn't work at all... it only provides a user login, in which when keyed correctly, gives me access to the 1 sheet that has already been made visible in the workbook and I still cannot view other sheets. Any ideas on what I can possibly do?

 

[Peter_SSs]

Any ideas on what I can possibly do?

Well, you could possibly try asking at the site wherever you got the starting code.
Another option might be to see if this thread has anything useful.

 

[Peter_SSs]

Isn't this thread asking the same thing as this one?

 

[helplessnoobatexcel]

Isn't this thread asking the same thing as this one?

Yep, it is. I was trying out different codes and was unsure on how I could update my previous question. Hence I posted another thread. Sorry for any confusion caused

 

[Peter_SSs]

Isn't this thread asking the same thing as this one?

Yep, it is.

Thanks for confirming.
So I am closing this thread per Forum Rules (#12) - posts of a duplicate nature will be locked or deleted.

unsure on how I could update my previous question.

In future, you just post (that is, Reply) in the original thread with any updated/changed information.