MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Password protect my macro


Posted by Chris Rock on August 03, 2001 11:54 AM

I'd like a password prompt to come up when a macro button is pushed, and ask the user to try again if the wrong password is entered, up to 3 times.

Can someone demostrate code to do this? Is the "up to 3 times" part possible?


Posted by newby on August 03, 2001 1:06 PM

This board is upside down..Mark W answer to my question is actually Chris question about password.look above..

Posted by Mark W. on August 03, 2001 1:24 PM

Hmmm...Chris broke it!!!!