|Oh, I see. |
Typically, the etiquette followed in this forum (and most others) is to actually ask for assistance as opposed to just announcing a set or requirements and expecting people to supply a solution. People want to help, but posts come across as sort of arrogant when all they do is read like a list of demands. I'm sure you didn't mean to have it sound that way, but it does.
That said, and since we don't know your level of expertise in VBA, I'll offer this as a starting point:
curUser = Application.UserName
This will set curUser to the UserName of the person logged into the machine at the time that the macro is run.
The current UserName could be compared to a list of allowed UserNames, perhaps stored in a hidden sheet, and if found, the sheet to be edited could be unprotected and then protected again when saved.
Obviously, the code module that contained the Password to unprotect the sheet would have to be hidden and password protected also.
Let us know if you need any further assistance.