Hi JeffP@Work,
Why wouldn't you put all your code in the template for these specific kinds of
documents? Why have any in an external Add-in at all?
Have you considered signing the VBA project in the template with a digital
signature? Or placing it in a trusted location? That should prevent any message
from coming up with security at med.
> I need my addin's modules to exec for only a specific template, so placing
> the code that calls that template works, but not with Med security settings,
[quoted text clipped - 40 lines]
> Setting the security back to Med., now I'm prompted that the doc contains
> macros, Arrrghh!
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
JeffP@Work - 26 Oct 2006 15:08 GMT
Cindy, you may see my inline. JeffP....
> Hi JeffP@Work,
>
> Why wouldn't you put all your code in the template for these specific
> kinds of
> documents? Why have any in an external Add-in at all?
JeffP: Because I was trying to overcome the Med security and I was hoping
that by putting the cmds in an addin I could leave the template void of
macros.
> Have you considered signing the VBA project in the template with a digital
> signature? Or placing it in a trusted location? That should prevent any
> message
> from coming up with security at med.
JeffP: I have considered it, but I need more reading on the subject on how
to implement.
However, I have another issue although I have the PsuedoNew/Open working
when I open the template, I get an hr glass for nearly 2 seconds before my
SQL data is refreshed, however if I run my clearFields macro, and then just
the UpdateFields macro it only takes a moment to re-query the SQL data and
refresh the fields, it appears that something is hanging....
To attempt a cure, I exported all the modules, recompiled, saved and
imported them back in, still the long pause on a fresh opening.
--------------
>> I need my addin's modules to exec for only a specific template, so
>> placing
[quoted text clipped - 62 lines]
> reply
> in the newsgroup and not by e-mail :-)