activate the euro tool add-in with VBA

[180drop]

Hi,

I have an excel 2003 workbook and would like to know how to automatically activate the euro tool add-in using VBA when the workbook is opened.

Hopefully someone can point me in the right direction.

Thanks.

[ragulduy]

Try:

Private Sub Workbook_Open()
AddIns("Euro Currency Tools").Installed = True
End Sub

in the workbook object module.

[180drop]

Excellent.

It works perfectly.

Many thanks.