RUN A MACRO IN AN EXCEL OBJECT

[IAC]

I need to run an XL macro within an XL object that has been create in a third party application. Any macro code will work in native XL, but will not run when inside the object...

For example if you run
Range("A3:B8&quot.Select
Selection.Font.Bold = True
inside XL it works as expected. However, if you try and run the same code inside an XL Object you get the following error
RTE 1004 Method "Range" of object "_global" failed.

 

[JESTAR]

I think you've only allowed that code to be run from Excel, thus the "global" error.