Protecting Sheets / Workbooks with Password - can't see password
When protecting sheets / worksheets with a password, there is no "eye" icon to display the password so you can verify that you've typed it in correctly. It would be great to have this function to help reduce errors and reduce the risk of locking yourself out of a file.
Absolutely agree with this suggestion. I just lost a day of work because I made the same data entry error on a password and now have no idea how to unprotect my file.
Yes it would.
******** password display is one of the stupidest things ever created. (Requiring passwords to be changed on a regular basis is another.)
One should at least have a click-to-display full plaintext of a password if desired. At an utter, absolute minimum, when establishing the passwordd.
(Only time I ever saw a use for the ********* masking was a car company for their car dealer software that put up random numbers of *'s when each character was typed so an eight character password might show 11 or 17 or 15 or whatever *'s rather than exactly eight. Still not enough value though. Sure beat the usual "Here, let me show you he uses 7 characters so you don't waste time crunching those pesky 4, 5, and 6 character versions trying to ***** it..." dislpay of one * for each character.)
By the way, to be safe while holding your breath for them to fix this, you can type it out somewhere else, be happy with it, then copy and paste it into their dialogue box. Sucky workaround, but it does work.