I'm working with a locked down external plugin (Cognos Analyst) for Excel. One of the functions it has is to create a shape (drawing object) and assign one of the XLA's macros to it. The XLA is password protected. The macro that is run when you click the button is "Analyst_SaveButton". This works when clicking it but when trying to call that macro through VBA, I get a "Unable to get the DrawingObjects property of the Worksheet class " error.

I'm pretty sure that it is using the Application.Caller property to retrieve the value of the shape it is running from. Is there any way in VBA that I can call the macro but as the shape so that Application.Caller will retrieve the shape name?

Thanks,
Jim