Spoof Application.Caller? Need to execute a shape's assigned macro as that shape through V
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1