Hi!
I have a cell (J2) and I only want people with a password to be able to unhide and edit this cell. I can't seem to figure out a way without having to "protect", "unprotect" (to make edits) and "re-protect" again.
Does anyone have any recommendations or advice on how to best achieve this?
To give some background - I will be sharing the file with another team who will need to make edits to the cell. I want to avoid them "re-protecting" the worksheet because I don't want to accidentally mix-up passwords. I just want to use one password, that I've created and shared with them.
Thank you!
I have a cell (J2) and I only want people with a password to be able to unhide and edit this cell. I can't seem to figure out a way without having to "protect", "unprotect" (to make edits) and "re-protect" again.
Does anyone have any recommendations or advice on how to best achieve this?
To give some background - I will be sharing the file with another team who will need to make edits to the cell. I want to avoid them "re-protecting" the worksheet because I don't want to accidentally mix-up passwords. I just want to use one password, that I've created and shared with them.
Thank you!