I want to protect specific Ranges in an Excel Sheet, but I want to give a permission for some Users. I know, that I can use:

Review> Changes> Allow Users to Edit Ranges > Permissions

But these Users are variable. I would like to write a macro that gives access to variable users. At the same time just the admin should know the password. Has anyone an idea how it might look like?

Best Regards Markus