Excel 2003 macro names
 

I am using Office 2003 on Windows XP.

If I create three identical macros and call them "a1", "aa1", and "aaa1",
only the last one called "aaa1" will work. I cannot go to
Tools-Macros-Run and run the first two macros.
I can step through them at design time, however.

Are there new name restrictions in Office 2003?

The macros I used are posted below.

Sub a1()
Cells(5, 5).Select
End Sub

Sub aa1()
Cells(5, 5).Select
End Sub

Sub aaa1()
Cells(5, 5).Select
End Sub

Excel 2003 macro names
 

I think you're probably right. I really though I had done it before, but I
tried it on a computer with Excel 2002 and it didn't work either.
Thanks for the quick response.
Ron Dahl


"Beto" wrote in message
...
Ron Dahl wrote:

I am using Office 2003 on Windows XP.

If I create three identical macros and call them "a1", "aa1", and
"aaa1",
only the last one called "aaa1" will work. I cannot go to
Tools-Macros-Run and run the first two macros.
I can step through them at design time, however.

Are there new name restrictions in Office 2003?

The macros I used are posted below.

Sub a1()
Cells(5, 5).Select
End Sub

Sub aa1()
Cells(5, 5).Select
End Sub

Sub aaa1()
Cells(5, 5).Select
End Sub


I'm not sure if you could do it in previous versions of excel, but I
think not, because "a1" and "aa1" might be interpreted as cells so it
gets confusing.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Excel 2003 macro names
 

Ron Dahl wrote:

I am using Office 2003 on Windows XP.

If I create three identical macros and call them "a1", "aa1", and "aaa1",
only the last one called "aaa1" will work. I cannot go to
Tools-Macros-Run and run the first two macros.
I can step through them at design time, however.

Are there new name restrictions in Office 2003?

The macros I used are posted below.

Sub a1()
Cells(5, 5).Select
End Sub

Sub aa1()
Cells(5, 5).Select
End Sub

Sub aaa1()
Cells(5, 5).Select
End Sub


I'm not sure if you could do it in previous versions of excel, but I
think not, because "a1" and "aa1" might be interpreted as cells so it
gets confusing.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Excel 2003 macro names
 

Ron

Excel thinks a1 and aa1 are cell references and won't allow them to Run or be
edited from ToolsMacroMacros.

Rename them if you want to run them from the ToolsMacroMacros.

Gord Dibben Excel MVP

On Mon, 19 Jan 2004 14:18:43 -0700, "Ron Dahl" wrote:

I am using Office 2003 on Windows XP.

If I create three identical macros and call them "a1", "aa1", and "aaa1",
only the last one called "aaa1" will work. I cannot go to
Tools-Macros-Run and run the first two macros.
I can step through them at design time, however.

Are there new name restrictions in Office 2003?

The macros I used are posted below.

Sub a1()
Cells(5, 5).Select
End Sub

Sub aa1()
Cells(5, 5).Select
End Sub

Sub aaa1()
Cells(5, 5).Select
End Sub