reference must be to a macro sheet

[itlsbu]

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

 

[pgc01]

Hi Steven

Cell addresses are not valid names in the worksheet environment.

Try for example to use the macro recorder to create a macro named A1 or D4 (or EW3) and you'll get the error message "Name is not valid."

Rename the macro.

Hope this helps
PGC

 

[itlsbu]

PGC,

Thanx for the response, I did not know that, I will try it
In the meantime I copied the macro in a existing module and than it did work...

anyway thanx for the reply

steven

 

[pgc01]

Hi again

In the meantime I copied the macro in a existing module and than it did work...

Yes, in a module there's no problem, you can have a macro called A1.

As I said the problem arises in the worksheet environment.

Kind regards
PGC