VBA: Use password to go to sheet
Solved/Closed
Andy.top
Posts
1
Registration date
Saturday June 19, 2021
Status
Member
Last seen
June 19, 2021
-
Updated on Jun 21, 2021 at 12:11 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 21, 2021 at 12:10 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 21, 2021 at 12:10 PM
Related:
- VBA: Use password to go to sheet
- How to reset windows 10 password without logging in - Guide
- How to recover facebook password without email and phone number - Guide
- How to enable vba in excel - Guide
- Number to words in excel without vba - Guide
- How to screenshot excel sheet - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
Jun 21, 2021 at 12:10 PM
Jun 21, 2021 at 12:10 PM
Hi Andy,
You end your code by going to the sheet, so you will always get there. Try placing 'Sheets("Bank Account").Select' before before 'Case Else'.
Or use the code below
I don't see anything about unprotecting the sheet, but I guess you'll add that later.
Best regards,
Trowa
You end your code by going to the sheet, so you will always get there. Try placing 'Sheets("Bank Account").Select' before before 'Case Else'.
Or use the code below
Private Sub CommandButton8_Click() Dim mPW As String mPW = InputBox("Enter Password", "Password Protected") If mPW = "Shewasadragon" Then Sheets("Bank Account").Select Else MsgBox "Incorrect Password" End If End Sub
I don't see anything about unprotecting the sheet, but I guess you'll add that later.
Best regards,
Trowa