I do my budget and one of the sheets is passwords. I have a pwd for the document but want to hide all the passwords which are on one of the sheets as well. What is the best way of doing this?
PS, keeping pwds and the risks understood.
Many thanks.
I need a pwd to ‘Show Sheet’! So I assume we do not have a method to do this so must think of something else. Thanks.
After hiding the sheet choose Tools → Protect Spreadsheet Structure… and set a password there.
Be aware that if the document itself is not encrypted (e.g. saved with password) those “protections” can be easily removed.
What is the BEST way of doing this?
Do not place passwords into a file what others can see or open.
But how does one hide the sheet? Any ideas? My pwds are obfuscated but I want trIpple protection hence needing to hide sheet by a different means. Thanks.
There is no solution it would appear.
This is not an answer to your problem - please use the More link under the answer to convert it to a comment, or delete the answer and edit your question to include it.
You want to protect, not hide, the sheet.
A more appropriate solution would be a proper password manager such as Bitwarden.
If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. That will help other people with the same question.
In case you need clarification, edit your question (don’t use an answer) or comment the relevant answer.