Here is the scenario: My group maintains informational spreadsheets for the
business. They are supposed to pull the most recent spreadsheet from our
Sharepoint site and update as appropriate and email them to use to repost.
They update the date on the template when changes are made. As a backup
process we'd like to add 1 protected cell on the spreadsheet where we'd
include an updated date so we'd know that they pulled it from the site sort
of as a version control from our end.
Is there a way to password protect that one cell easily and be able to just
enter the password update the cell and then save the document straight away
without having to reprotect the cell each time?