Something you said about "4 different supervisors".
They're not opening t he file at the same time? are they?
If so, only ONE set of changes will be stored. all others will be discarded.
If they're working different shifts, then it shouldn't be a problem.
I assume that if the supervisor is called away, and doesn't get back to it
until
the next day, and in the meantime, another supervisor has been in-and-out
of this, then:
What I would do is: Create a text file on the user's system, under the
user's login ID.
For each "feature" you're wanting to return write to the file "something"
that you will be able to read later to use as an indicator for returning.
You'll need things like: ActiveCell. Userform displayed, and even
userform values selected... then, simply read through the file and reset
the things as he left them.