Disabled macros and won't run

[maclis]

I have a workbook with a macro in a module file called by Ctrl+D but this fails with the error "Cannot run the macro. The macro may not be available or all macros may be disabled".

In the developer tab I can see the macro but the "run" "step into" and "edit" options are all disabled.

macro security is at its lowest setting and the option to trust the vba project is enabled.

any thoughts ?

 

[shg]

What's the macro's signature? (The Sub Whatever line)

 

[maclis]

What's the macro's signature? (The Sub Whatever line)

don't think the macro is signed. I have found a way to re-enable the macro by running this code from inside the developer tab

ActiveSheet.Unprotect
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=True

the environment of the workbook is a little odd; its stored inside an SAP BPC server and the Workbook.Open does not execute otherwise I could have just added this code to this macro.

Regardless, I think I have a solution but any idea what aspect of WORKSHEET PROTECTION blocks macros ?

 

[shg]

What is the first line of the macro -- the one that starts with Sub?

 

[shg]

its stored inside an SAP BPC server

I retract my question; I have no idea how Excel works inside SAP.

 

[maclis]

Yes, its almost certainly due to something within SAP BPC addin but thanks for your help regardless