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

Philippon,

I'm a little puzzled on the crashes, but for the macro's to show up in the
macro box
it needs to match these criteria:

- The add-in containing the macro is opened.
- The macro is not a labelled Privat.
- The macro is not a Function.
- The macro does not have any arguments. So the macro is called like Sub
JCFshow(), without anything between the brackets.

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl


"Philippon" schreef in bericht
...
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 macro
works perfectly.

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

Is there any declaration of macro, add-in that could be missing and
that would explain why the macros are not in the list and why when I
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-Ins


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

Phillipon

Macros in Add-ins will not show up in the ToolsMacroMacros list.

I think you might have too many JFC's......in module name and in Macros.
Excel can get confused between modules and procedures.

Try re-naming JFC_02_02 to something else and see what that does for you.

Gord Dibben Excel MVP

On Tue, 23 Dec 2003 01:17:39 +0100, "Quandan - Marcel Kreijne"
wrote:

Philippon,

I'm a little puzzled on the crashes, but for the macro's to show up in the
macro box
it needs to match these criteria:

- The add-in containing the macro is opened.
- The macro is not a labelled Privat.
- The macro is not a Function.
- The macro does not have any arguments. So the macro is called like Sub
JCFshow(), without anything between the brackets.

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl


"Philippon" schreef in bericht
...
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 macro
works perfectly.

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

Is there any declaration of macro, add-in that could be missing and
that would explain why the macros are not in the list and why when I
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-Ins


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