Stop until Calculationstate = xldone
 

Ok . Tx! i hoped that was the case. .then a complete different thing:

I'm using an activeX class in VBA

A certain sub is being dealt with and normally this triggers an event
(like workbook_open etc. but then for a total dfiferent class)
specifically for this class...

However when i embed this function (including event that should be
triggered) into a broader sub it appears the event isn't triggered
anymore and it just moves along..

Anyone an idea on how to move to this event anyway?

Thanks. Ivo


--
Tornados
------------------------------------------------------------------------
Tornados's Profile: http://www.excelforum.com/member.php...fo&userid=4178
View this thread: http://www.excelforum.com/showthread...hreadid=264131