Macro editor problem

[Seeker]

I don’t know what I have done, when thru Tool bar>Tools>Macro>Macros (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

 

[OssieMac]

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.

 

[Gord Dibben]

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