View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default OleObjects very urgent issue

Hello,

I have inserted an ActiveX in the Activesheet and so far I was able to
reference its Object property.

For example MsgBox TypeName(g.object) will return "CircleGauge1" , the
name and index of the the control . g is defined as OleObject

Strangely and suddenly, the same command returns "RunTime1004, unable
to get the object property of the OleObjects class" although the
ActiveX in properly registred

What is more strange is that from time to time it starts to work again
but I could not figure out the logic

I am really stucked and your help will be very appreciated
Avi