Does your code make changes to the addin?

If so, that could be the problem on the prompt to save.

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
...
I created an Addin. I have distributed to several work
collegues to have them test it. They have dowloaded it
into their My Documents folder and then installed it into
Excel via Toool\Addin\Browse\My Documents\Addin file.

I password protected the xla file. However whenever we
close Excel we get prompted if we want to save the changes
to the XLA file. This is confusing as its password
protected. I do not want to five anyone acccess to it.
Yet when I go to the VB Editor and click on the xla it
prompts me for a password.

Furthermore, my one colleague was showing me that although
it was clicked off in the Addin list, it was not appearing
as it should in her Menu items. So we clicked it off and
then on again and the mene item appeared.

Does anyone know what is going on here?

Thanks