Thanks Ivan,

This is actually Subclassing in Excel Not Hooking and still it does WORK !!!
with no appearant adverse effect ! ....first time I see Subclassing in an
Excel environement without freezing or crashing the whole application
:)....Beautiful work Ivan.

I'll study the code and see if I can adapt the same concepts to different
scenarios.

Ivan, do you have any code that subclasses the XL application (or any of its
child objects) as opposed to a UserFom ?

Regards.

Jaafar.



"Ivan F Moala" wrote:


For an example of Hooking have a look here

http://www.xcelfiles.com/API_Userform_MenuMaker.html


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=390920