If you don't want to change your original macro, nor post anything here for us to look at, an additional macro would be needed, yes?
Create a macro for those users that get to enter a password and make changes. The macro asks for their password, if it is correct, then it unprotects the sheet AND reenables saving capability, perhaps through another macro button onscreen if you wish.
Bookmarks