Adding a reference to VBA code add-in

[tomguest]

Hi

I have a Excel Add-in that I want to keep password protected. One of the references that is needed to be added via the tool->references is Microsoft XML, v2.0

The user is unable to add this without knowing the password. I've thought about adding it via some VBA code but there is a problem with that.

When Excel is started, after installing the add-in, an error is shown that there is a problem in the VBA code - basically a variable is defined and the variable type is defined in the xml reference I'm trying to add. Excel does not load any of the VBA code so I can't add the references at that point programmatically.

I can then get the user to manually run a macro that adds the references to the add-in. The problem is that I would then want the user to be able to save the xla file so the references get saved with it. Since it is password protected this is not possible.

Is it possible to

a) save the xla file via VBA in the xla file (sounds doubtful)

b) add references to a general template that adds the references to all files loaded in excel

or does anybody have any suggestions/solutions?

Cheers

Tom