Password Protecting Sheets by User

[korstan2]

Hello,

I am trying to duplicate a spreadsheet using the code from the link below (post #3) and am running into a small issue. Whenever I go to close the file, that same spreadsheet appears again (showing only the "home" tab) asking me to save again. Is there something I am missing in the code that is causing this to open? Sorry, I'm pretty new to this

Password Protect Viewing for Multiple Worksheets

Going off this link, I used the script within, and it works for single sheets. However I need some users to access multiple sheets, and some users to only have access to one. Is there a way to adjust the script to allow for this? I tried the suggestion but am unaware of the FINDNEXT function/how...

www.mrexcel.com

 

[dave3009]

Hi and welcome to the board,

It might be better to see your implementation of the code as the example is reported as working.