Add-In Question
 

I have createed an AddIn following the steps outlined here
http://tinyurl.com/genql.

So I have an addin *.xla file. I have successfully added it through
Tools -- Addin, and checked the box next to my Addin's name.

However when I try to fire the macro in the Addin via Tools, Macro,
Macros, nothing appears in the Macro box.

I renamed Module1 to MainModule and put my public function there, but I
don't think that would cause it.

Any idea what I did wrong?

(Excel 2000, Addin written in Excell 2000 VBa enviroment)


--
Fountainhead
------------------------------------------------------------------------
Fountainhead's Profile: http://www.excelforum.com/member.php...o&userid=32825
View this thread: http://www.excelforum.com/showthread...hreadid=526302

Add-In Question
 

You won't see it. Press <Alt<F8, and in the macro box type in the name.
It will run


"Fountainhead" wrote:


I have createed an AddIn following the steps outlined here
http://tinyurl.com/genql.

So I have an addin *.xla file. I have successfully added it through
Tools -- Addin, and checked the box next to my Addin's name.

However when I try to fire the macro in the Addin via Tools, Macro,
Macros, nothing appears in the Macro box.

I renamed Module1 to MainModule and put my public function there, but I
don't think that would cause it.

Any idea what I did wrong?

(Excel 2000, Addin written in Excell 2000 VBa enviroment)


--
Fountainhead
------------------------------------------------------------------------
Fountainhead's Profile: http://www.excelforum.com/member.php...o&userid=32825
View this thread: http://www.excelforum.com/showthread...hreadid=526302

Add-In Question
 

The add-in will have to make a menu to access the routines in that add-in.
Type in Google: Add-in Excel tutorial
And it all will be explained nicely.

RBS

"Fountainhead"
wrote in message
...

I have createed an AddIn following the steps outlined here
http://tinyurl.com/genql.

So I have an addin *.xla file. I have successfully added it through
Tools -- Addin, and checked the box next to my Addin's name.

However when I try to fire the macro in the Addin via Tools, Macro,
Macros, nothing appears in the Macro box.

I renamed Module1 to MainModule and put my public function there, but I
don't think that would cause it.

Any idea what I did wrong?

(Excel 2000, Addin written in Excell 2000 VBa enviroment)


--
Fountainhead
------------------------------------------------------------------------
Fountainhead's Profile:
http://www.excelforum.com/member.php...o&userid=32825
View this thread: http://www.excelforum.com/showthread...hreadid=526302

Add-In Question
 

Macros in add-ins aren't shown in the macro dialog box. When you
write an add-in you need to also write the user interface for the
add-in, typically menu items or a command bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Fountainhead"
wrote
in message
...

I have createed an AddIn following the steps outlined here
http://tinyurl.com/genql.

So I have an addin *.xla file. I have successfully added it
through
Tools -- Addin, and checked the box next to my Addin's name.

However when I try to fire the macro in the Addin via Tools,
Macro,
Macros, nothing appears in the Macro box.

I renamed Module1 to MainModule and put my public function
there, but I
don't think that would cause it.

Any idea what I did wrong?

(Excel 2000, Addin written in Excell 2000 VBa enviroment)


--
Fountainhead
------------------------------------------------------------------------
Fountainhead's Profile:
http://www.excelforum.com/member.php...o&userid=32825
View this thread:
http://www.excelforum.com/showthread...hreadid=526302