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