RJSIGKITS
Board Regular
- Joined
- Apr 15, 2013
- Messages
- 109
Hi Guys.
Trying to achieve a hidden sheets (No visible tabs) type scenario, but to allow visibility with a Button Control.
So far, I have played with hiding the sheet by right clicking the tab and selecting 'Hide'
I currently have a Comand button with the following Code:
However, when this is clicked, it ignores the hidden sheet and goes to the next sheet along.
On top of this, I really wanted the hidden sheet to be more securely hidden, by using the sheets VB property of xlSheetVeryHidden.
Any ideas from you Genius people?
Thanks in advance.
Trying to achieve a hidden sheets (No visible tabs) type scenario, but to allow visibility with a Button Control.
So far, I have played with hiding the sheet by right clicking the tab and selecting 'Hide'
I currently have a Comand button with the following Code:
Code:
Private Sub CommandButton12_Click() Dim pword As String
pword = InputBox("Enter the password to Continue.", "Password Required!", "Type Password")
If pword <> "Bobby12" Then
MsgBox "Incorrect Password", vbExclamation + vbOKOnly, "Error"
Exit Sub
Else
MsgBox "Success! Click OK to Proceed", vbInformation + vbOKOnly, "Success"
ThisWorkbook.Sheets("Supplier Order Log").Activate
End If
End Sub
However, when this is clicked, it ignores the hidden sheet and goes to the next sheet along.
On top of this, I really wanted the hidden sheet to be more securely hidden, by using the sheets VB property of xlSheetVeryHidden.
Any ideas from you Genius people?
Thanks in advance.