If a user tries to modify my sheet, my VBA code immediately
shows a userform which asks for a passwords to get access
to the sheet....

So, I've been thinking... would it be better to just scan the
Environ("Username") info and only automatically give access to
select users?? It saves the need of prompting for passwords
every time. Is this a reliable solution? What problems might
arise from this solution?

Thanks.