Macros won't run

[mesteptoe]

I have an Excel 2010 workbook which contains many macros. However, they have now stopped working and I get the warning "Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled". I have got into Macro Security and "Enabled all macros" but they still won't run. It is a macro enabled workbook.

Any thoughts as to what to do?

Thanks

Graham

 

[RoryA]

Did you reopen the workbook after changing your macro security settings? (Note: I wouldn't generally recommend that setting. I prefer to disable all with notifications so I can choose what to run when I open it)

 

[mesteptoe]

Yes it was re-opened but no luck. I would agree about not using that setting and it used to run by asking you to enable macros. But I'm getting desperate now so thought I would reduce security to a minimum.

 

[RoryA]

How are you trying to run the macro? Can you see and run it from the macros dialog?