Add-In Question

[Fountainhead]

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)

 

[Guest]

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

 

[RB Smissaert]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Chip Pearson]

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"
in message
news:[email protected]...