Have you clicked on your workbook/project in the Project Explorer window of the
VBE?

You will probably get a password dialog because the project is locked for
viewing.

Supply a password to unlock.


Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 16:25:49 -0000, wrote:

I am assisting a customer running Excel 2003 on a Windows
2K system. He has lost the ability to edit macro on a file he created.
From the Tools Macro Macros screen, the only buttons available are
run & cancel. Everything else is grayed out. I tried editing the macro
from Visual Basic -Tools-Macros- same issue. It isn't a protected or
shared worksheet. Any ideas?

Thanks.