Make sure that

- they are nor Private subs (Private Sub myMacro())
- the code module in the add-in doesn't have Option Private Module at the
start
- the subs and/or functions do not have arguments




RP
(remove nothere from the email address if mailing direct)


"salooha" wrote in
message ...

Hi there,
I am working with excel 2k and xp, I created a workbook that has all
the macros that I use and I am trying to create it as an Addin.

I saved the workbook with a .xla under c:\documents and
settings\username\application data\microsoft\addins but still it
doesn't work as an addin...

I go to tools -- addins -- then browse to the location of the file
and I added and make sure it is checked but when I open excel and go to
macros, i don't see any of the macros....even with the addin checked.

i would like to be able to click on the .xla workbook and it add itself
to excel or at least when I add it by goint to tools -- addins and
check it, it would be available throughout excel everytime I open
it...

I know that I could save the workbook in XLstart to be available
everytime I open excel but I don't like this feature plus I would like
to be able to pass on the xla file to other people to install on their
machine.....

I checked microsoft website for creating an excel addin and I followed
the steps but it still doesn't work.....

any help please is highly appreciated....

you can also email me at

thanks a lot


--
salooha
------------------------------------------------------------------------
salooha's Profile:
http://www.excelforum.com/member.php...o&userid=14612
View this thread: http://www.excelforum.com/showthread...hreadid=381021