Log In
Register
Home
VBA form Password protect
Steven Behr
Member
Members
Forum Posts: 94
Member Since:
January 30, 2020
January 30, 2020
Offline1
March 16, 2020 - 3:20 pm
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
Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Forum Posts: 1939
Member Since:
November 8, 2013
November 8, 2013
Offline2
March 16, 2020 - 4:52 pm
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Philip Treacy
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 338
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Lennard Wood
Miguel Costa
Nick Dowling
Silvia Ramos
Muhammad Abdullah Asad
Ifeanyi Aghanama
Ann Crossman
Kate Manders
James Carabott
Steven Venz
Forum Stats:
Groups: 3
Forums: 25
Topics: 7068
Posts: 30976
Member Stats:
Guest Posters: 49
Members: 34460
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —