I create a VBAProject called test.xls
I compile an addin now called test.xla

I have 1 function and 1 subroutine in text.xls that work fine.

That function and subroutine are also duplicated in the module of
test.xla

I load the addin into a second file test2.xls

The function and the subroutine work fine in test2.xls

However, I notice that any changes I make to the addin have to be
replicated
in test.xls

It seems that, in order for the addin to work there must be identical
copies of the code in both the worksheet and its associated addin
file.

What am I missing? I don't think this is correct and want to know the
proper way of maintaining addin code.

Any help greatly appreciated

Jeff Stryer