So I have a file with 19 sheets, 18 of those sheets are hidden with the 1 unhidden one being the Home tab. On the home tab there are cells that take you to the hidden sheets when they are double clicked. Once you get to the hidden sheet you are prompted for a password and that will either hide the sheet and send you back to the home page or it will give you access to the sheet. Before I password protected each sheet so it would just send you back I had locked all of the sheets and password protected them and every time you hit save it would collapse all of the groups, lock the page, and send you back to the hone sheet. Now that I've password protecting each sheet I don't need to lock the sheets but I still want them to collapse and send the user back to the home page when they hit save. Below is the code that I'm using to do this, but what I don't know is what do I need to get rid of to keep the functionality the same but remove locking the sheets?
For the home (Quick Look) sheet:
For each hidden sheet:
And finally for the workbook:
Bookmarks