'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 |