[Noob] Is it possible to protect the Re-open function?

Copper Contributor

When I try to protect a table with a password, I can't impede the user to re-open hidden columns. How do I block the Re-open function?

1 Reply

First Read this Link:
https://support.microsoft.com/en-gb/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75...

Then read this Link:
https://support.microsoft.com/en-gb/office/protect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b59...

or if you like with a VBA solution, after you lock desired cells

Private Sub Worksheet_Activate()
Dim strPassword As String
strPassword = InputBox("Give you Passwort:")

On Error GoTo Falsch
Me.Unprotect strPassword
Me.Protect strPassword
On Error GoTo 0
Exit Sub
Falsch:
MsgBox "Wrong Passwort"
Worksheets("Name it").Activate
End Sub

If you have after that a question, will be happy to answer/help.