I say "WOW!" back to the depth of your suggestions and
questions. Thank you all, indeed. It gives me several different
levels of reponse--as well as forcing me to have to make some
decisions about how it relates to each supervisor.
I checked first on David's suggestion in regards to WindowsKey-L
and I had to call in to ask my wife if that would work and she
wasn't sure if it would make them have to re-logon to their entire
network, etc. which is somewhat time consuming and since they often
get many interruptions during a shift that wouldn't be good. She's
going to check on that. The other problem with it, though is the
multiple supervisor situation, so I don't think locking Windows will
work. I was good to think about, though, and might come in handy
with other situations.
In regard to Paul's comment about them working at the same
time, that issue had previously been raised between me and the sups,
and while they do work different shifts, they occasionally come in
on their days off to catch up their reports, so at times they will
need to have more than one working at the same time. The data is
sorted by teams, though, so I was planning to save each team sheet
individually. I haven't got to that part yet, so I don't know how
well that will work . . . they do need overall stats, too, so I've
got to work out a way to integrate the teams for the final monthly
reports.
The general idea of the design to put the needed "return to
previous" info into a separate file was somewhat similar from both
Paul and TechnologyMD, so I'm working on doing it that way.
In answer to the questions about where they would go back to,
they are each responsible for a different team, which is already
sorted by worksheet now, so they would each go back to their own
specific location. I'm thinking that the login/password design
would be the way to keep that sorted . . . when each sup logs on,
they would automatically go back to the last call they were working
on. I don't know of a reason that they would need to go anywhere
else, because all the relevant userforms are accessible by command
button to each other, so they can easily move between them.
As for the shared workbook, at this point I had planned to do it
that way, but I'm not sure if that's the best way. I'll have to do
some more thinking on that.
As for hiding the window versus shutting down Excel, I'm not
sure about that, either. At this point, I"m thinking that those
machines are being heavily used, so having too many application
going might bog them down, which doesn't sound like a good idea to
me. So, I'll do some checking on that, too. The other thing would
be,wouldn't that make it hard for another supervisor to log on
(assuming I can get the save part to be separated by teams)?