Posted by Paul Magruder on July 31, 2001 3:45 AM
I am using a password to allow a user access to run a macro. The problem is the user has to enter the password everytime they press the button to run the macro. What I would like is for the user to only have to enter the password the first time they press the button, and not have to enter the password the remainder of times they run the macro until the workbook is closed. ....Excel 2000
MyPassword = InputBox("Please enter password", "Password Prompt", "********")
If MyPassword = "performance" Then
MsgBox "Access Granted", vbInformation, "Access"
MsgBox "Access denied", vbCritical, "Error"