No "Edit" button in macro screen.

[George Wilson]

I am assisting a customer running Excel 2002 on a Windows
XP system. It seems he has lost the ability to edit macros
from the Tools > Macro > Macros screen, the button is
grayed out. Only the Run, Cancel and Step Into buttons are
available. If he goes to The visual basic editor and goes
to Tools > Macros, the buttons are active in this menu.
The security setting is not an issue, the file is not read
only, These are macros he is writing and had this
funtionality earlier this week. I checked to make sure the
macros are not protected and no passwords are set. What
else would make this functionality dissapear?
TIA
George

 

[Gord Dibben]

George

I assume you can see the macro name in the dialog box?

Is it possible you have protected the VBA Project?

Hit ALT + F11 and select the workbook/project and
right-click>Properties>Protection tab.

Is it locked for viewing?

You will probably need a password if that's the case.

Are the macros in Personal.xls which is hidden?

Unhide it and see what transpires.

Gord Dibben Excel MVP