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
www.mrexcel.com
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...