Hi,

I have a macro enabled template that has been evolving over several years. Lately, it shows some really odd behaviors:

1. When I double-click it to spawn an instance of the template, the macro execution is really slow. It is not isolated to any specific code snippet, it is a general thing. Once I save it, close Excel, and open the saved file, it executes at the excepted speed. Every time. I've also dug up old versions of the same macro template that has not preciously shown this behavior; they are now showing the same symptom.

2. The other really odd thing is that when I close the newly created instance, the dialog box to enter the password to access VBA-macros is somtimes (not always) displayed. This behavior also goes away once I save the instance and reopens it.

I can come to no other conclusion than that there is something going on in my computer that somehow interferes with Excel (at least to cause [1]. [2] is just weird).

I'm not really expecting anyone to know the exact cause, but if anyone has had similar mysteries and resolved them, pointers to strategies to do so would be appreciated.

Thanks!