Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
15
Views
Topic starter
Hi,
Im wondering, I understand password protections with sheets in VBA.
But I cant seem to understand if there is a VBA FORM password protection. So when a person opens a form that have to use a password to access that form.
If someone can give an example or link that would be great
Steve
Posted : 17/03/2020 1:20 am
Hi Steven,
You don't need a form password to do that, there is no such thing.
Collect user password with a text inputbox, check it, and if it's correct, display the form:
Pass=Inputbox("Type your password")
If Pass = "MyPassword" Then
userForm1.Show
Else
msgbox "Wrong password!"
End if
Posted : 17/03/2020 2:52 am