Hi
I use Excel 97.

When I try to run a macro located in my Add-In without opening VBA
Excel crashes. However, if I open VBA and close it, then the macr
works perfectly.

The same kind of crash occurs if I open the Macro list and strike th
first 3 letters of my macro. My add-in is called JCF_2_2, my macro i
called JCFshowlookup, so when I strike just JCF, I have a crash. I hav
to say that the maccros I have in the add-in are not listed in th
macro box.

Is there any declaration of macro, add-in that could be missing an
that would explain why the macros are not in the list and why when
open VBA, the crash does not occur ?

Many thanks and Happy Christmas to all...
Pierre
PS: as you may have noticed, I am a beginner with Add-In

--
Message posted from http://www.ExcelForum.com