Remove macro is greyed out - help required

[Beemer]

I want to remove a sort macro that I made which is in a workbook that I
made. When I go Tools|Macro|Macros I see the macro but the delete button is
greyed. How can I remove the macro?

Beemer

 

[Dave Peterson]

Sometimes, the project is protected by the developer. But if you created the
macro, then you know if you protected that project. Did you?

Do you get prompted for a password when you try to access the project (inside
the VBE)?

 

[Gord Dibben]

Perhaps you have shared the workbook?

That will render the Tools>Macro>Macros>Delete button unavailable.


Gord Dibben MS Excel MVP