Password Protect Specific Textboxes in Excel Userform
Posted on 2013-09-22
I have a userform with some textboxes.
I created a button that disables some of the textboxes so no information can be entered.
Then I created another button on the userform to re-enable those textboxes.
What I am looking for is some code that if the button to re-enable those textboxes is clicked that another box pops-up that asks for a password.
If the password is entered correctly those textboxes are re-enabled and if the password is incorrect they receive an error message and those textboxes remain disabled.
Here is the code I used to disable the TextBoxes
Private Sub LockDataButton_Click()
RrtNm.Enabled = False
Loc.Enabled = False
Tier.Enabled = False
GeoCde.Enabled = False
DivCmb.Enabled = False
RegCmb.Enabled = False
OpgDt.Enabled = False