.
You can't do that with a Message Box.

You will need to create a UserForm that looks like a Message Box and include the macro for the password.