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
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