Hopefully someone can point me in the right direction on what is causing
this and how to fix it.

I have a macro that emails a selection to a specified address. Sometimes
when I press Alt-F8 the run button is disabled. When this happens the name
of the macro is ThisWorkbook!Send_Mail

At times, the macro works fine and the run button is enabled but I have
noticed that when it is, the macro name is ThisWorkbook.Send_Mail (period
instead of an exclamation)

When it is an exclamation point, clicking edit and then closing the vb
window SOMETIMES allows me to run it.

Can someone point me in the right direction to resolve this. I have no clue
on why this is sporadically happening.

Always the same computer, using Excel 2000.

Thanks

Charlie