Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Spoof Application.Caller? Need to execute a shape's assigned macro as that shape through VBA

Status
Not open for further replies.

jim2011

IS-IT--Management
Jun 26, 2012
5
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top