AW: Arbeitsblatt sperren
23.08.2019 09:54:30
Torsten
Hallo Georg,
blende dein zu schuetzendes Blatt aus und kopieren den folgenden Code in deinen Workbook code.
Siehe Kommentare, was zu aendern ist:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim xSheetName As String
xSheetName = "Sheet5" 'hier Blattname angeben, was geschuetztwerden soll
If Application.ActiveSheet.Name = xSheetName Then
Application.EnableEvents = False
Application.ActiveSheet.Visible = False
response = Application.InputBox("Passwort eingeben, um Blatt zu entsperren.", "Blatt _
Geschuetzt", "", Type:=2)
If response = "123456" Then 'hier Passwort angeben
Application.Sheets(xSheetName).Visible = True
Application.Sheets(xSheetName).Select
End If
End If
Application.Sheets(xSheetName).Visible = True
Application.EnableEvents = True
End Sub
Gruss Torsten