I dont know what I have done, when thru Tool barToolsMacroMacros (or call
dialogue box Alt, F8 direct), €œedit€� is gray out, it does not happen in other
books.
Any idea what had happened and how to fit it please?
Rgds

Firstly are they your macros or have the macros been protected by someone else?

If not the above.
Select Tools - Macro - Security. - Security level tab.
Select Medium (You should then be asked if you want to run macros when
opening workbook)
Then select Trusted Sources tab and check the box against "Trust all
installed addins and templates".
Click OK and then exit workbook.
Open workbook again and see if it fixes the problem.


--
Regards,

OssieMac


"Seeker" wrote:

I dont know what I have done, when thru Tool barToolsMacroMacros (or call
dialogue box Alt, F8 direct), €œedit€� is gray out, it does not happen in other
books.
Any idea what had happened and how to fit it please?
Rgds

Are the macros listed in the dialog box and you have two
choices...........run or cancel but you cannot select one to edit?

I would suggest the workbook is shared.

Unshare to regain editing capability.


Gord Dibben MS Excel MVP

On Sat, 30 May 2009 17:56:01 -0700, Seeker
wrote:

I don’t know what I have done, when thru Tool barToolsMacroMacros (or call
dialogue box Alt, F8 direct), “edit” is gray out, it does not happen in other
books.
Any idea what had happened and how to fit it please?
Rgds