hello,
I have a simple macro (see below). When I try to assign it to a button, I get the message "reference must be to a macro sheet". Never had that before and even after searching for a hour I have no idea what I have done wrong or what it is I am missing.
Help would be appreciated
Sub EW1()
'
ActiveSheet.Unprotect
Columns("A:E").Select
Range("E1").Activate
Selection.EntireColumn.Hidden = False
End Sub
thanx steven
I have a simple macro (see below). When I try to assign it to a button, I get the message "reference must be to a macro sheet". Never had that before and even after searching for a hour I have no idea what I have done wrong or what it is I am missing.
Help would be appreciated
Sub EW1()
'
ActiveSheet.Unprotect
Columns("A:E").Select
Range("E1").Activate
Selection.EntireColumn.Hidden = False
End Sub
thanx steven