'Runtime error 1004 Application defined or object defined error

I am getting a Runtime error 1004 and when I debug it, it takes me to this sub, this sub works fine in another sheet, I don't know whats wrong, can anyone help??

Public Sub allowEdit()
  Me.Unprotect PASSWORD
  Application.ScreenUpdating = False
  Me.Columns(HIDDEN_DATA_RANGE).EntireColumn.Hidden = False
End Sub


Solution 1:[1]

ThisWorkbook.Worksheet("SheetName")

Did the trick.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 smooky.secrets