How to write Macro for Retry Password entry when open Excel

[EvelynLoh]

Dear all expert

I have an excel document that's password protected to open. If the password is incorrect it asks to verify caps lock is not on in a message box with an OK button. Clicking OK makes the msgbox go away and the user is left with a blank excel window which needs to be closed before re-attempting to open the file and given another try at the password. We often use capslock and it's pretty common to get this message. We then have to go through the close&reopen process, which is a hassle.

I'm looking for some VBA code that when detect PasswordFail presents the user with a msgbox saying, "The password you entered is incorrect. Check that it's right, make sure capslock is off, and try again" along with another Password field and OK/Cancel buttons.

Does anyone have a VBA way of doing this or can someone point me in the right direction to finding an answer?

Thank you soo much for your advise. Any input is welcome.

[FDibbins]

This could almost be considered as trying to get around the password protection. I would think the whole purpose of not giving you a 2nd (or 3rd or 20th) chance is to make it more of a hassle to keep trying to "guess" the password.

[EvelynLoh]

This should not be the way..

Most of the application allow chance to retry for the password. So is there any macro allow user to retry the password?

Thank you.

[dominicb]

Good morning EvelynLoh

A macro cannot run until the file is opened. The file will not open unit the password is input correctly. A macro is not the way forward with this.

Why not remove the password, and have the file located in a folder with Windows pemissions set up so that the only certain users can access the file?

HTH

DominicB