Hi all, I have a sheet that has a main tab updated with data from sheets that I normally hide. The tab is fully locked down apart from a cell where users have a drop down tab to select a particular month. The sheet is saved on a Sharepoint accessible to around 60 volunteers of a charity.
I am the only one who makes changes to this backing data and to avoid any unwanted changes or details being deleted I hide the information sheets and protect the entire workbook structure with a password. I then save it to sharepoint. If I am the next person to open it, the protected structure remains in place and requires a password to unhide the information sheets. If another user opens the workbook to view the information and they close it, the sharepoint site updates but it removes the protected sheet status allowing the next user to unhide and edit what should be hidden tabs.
Any idea how I can stop this happening?
Bookmarks