Forum Discussion
Allowing different users to view their data by entering a password
I have a spreadsheet with a tab for each hub of the business. Instead of creating 12 spreadsheets and sending out individually, I need to allow access to a file located on the server, when they o...
I'm not sure about the landing hub but you can protect individual sheets within a workbook and assign a password to each. If you don't know where to do that - you'd go to File>info>protect workbook>protect current sheet. What I do is lock columns that I don't want everyone to view then protect the sheet so that the content doesn't show up if someone random clicks on that sheet/tab. You could label each tab and people would look for theirs and then proceed to unprotect to unhide and view their content?
Apologies for wasting your time if you're aware of this bit, am in a workbook that has protected sheets and came looking for an answer to frozen panes acting strangely, saw your question and thought maybe I could be helpful.
Gayle