VBA code lock tab with password

[Shamz41]

Hi All,

I require a few help for an attendance chart which I'm trying to mod as attached.

1. I need to hide the sheet 1 (Time Log) and only be able to view/edit with a password. I have this VBA code and pasted it into the worksheet but am facing a debug error. Can anybody see where I've went wrong. I've removed the code from the workbook and pasted it here.

The password is currently set to code1



Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim MySheets As String, Response As String
MySheet = "Sheet1"
If ActiveSheet.Name = MySheet Then
ActiveSheet.Visible = False
Response = InputBox("Enter password to view sheet")
If Response = "code1" Then
Sheets(MySheet).Visible = True
Application.EnableEvents = False
Sheets(MySheet).Select
Application.EnableEvents = True
End If
End If
Sheets(MySheet).Visible = True
End Sub


2. I would like to insert a user/ date time stamp on sheet 3 (scan) in the date columns. when an input is keyed in column b (Scan in) user/ date time stamp is created.

Any assistance will be greatly appreciated.

[Richard Buttrey]

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Shamz41]

Hi

Thanks for the reply. Did I wrap the code correctly as per forum rules?

Please Login or Register  to view this content.

[Keebellah]

Your code was incorrect.
I've attached a working sample.

[Shamz41]

Hi Keebellah
Thank you for the reply. Thank you for showing me the right path!! realized though that I can still unhide the tab if I right click on them. Is there any way to not enable that or create a password to block?