"GS" wrote in

The most reliable way is to use built-in sheet protection. If users are
not supposed to make unauthorized modifications to your sheet[s] then
the presumed inconvenience of being prompted for a password is a mute
point, IMO.

On the other hand, using Environ to qualify logged in users for
authorization is a nice touch since you can compare that to a stored
delimited string list of usernames via the InStr() function fairly
easily. I agree with Auric_ though, that the list might be problematic
to maintain.


We only have two supervisors who will have special editing
privileges. All other users will have very limited privileges to the
workbook. So, in my case, the list of users to maintain will always
be very small... but ya, I agree with you and Auric that if my list
of users was large and non-static, then maintaining a user
list would be problematic.

Thanks for the ideas Auric and GS.