creating ADD-INS in Excel 2000

[marco02]

Hi

I have my Excel VBA program up and running ) and i would like to make it an ADD-IN.

I didn't manage so far. Could somebody tell me what are the steps ? I think i'm missing something.

Or does somebody knows a weblink that would be helpfull?

Thanks in advance,

marco

 

[marco02]

hey marco there's nothing easier than creating an add-in in Excel 2000 ...

1) unhide your Workbook if needed

2) save it as .xla using the SAVE AS button
windows will probably set the default saving path
as
C:\Documents and Settings\Administrator\Application
Data\Microsoft\AddIns
if not do it yourself : save your workbook.xla in it

3) go in the add-ins menu and click on your add-in! Make sure you have an auto_open sub to launch the initialization ...

p.