For use on your computer only see help on creating a digital certificate using
the Office SelfCert tool.

Sign your workbooks with that signature.


Gord Dibben MS Excel MVP

On 10 Mar 2008 19:50:04 GMT, (Jeff Korn) wrote:

When I open certain Excel or Word documents then I am always asked if I want to enable or disable
embedded macros.

How can I permanently active these macros (when I open the document later again)?

However I do NOT want to change the document file itself.
Other user who may have access to the documents as well should have the choice to
disable them).

I could imagine that MsOffice resp. Word/Excel maintains an internal list
where "always activate macros for docs" are entered and remembered.

If this is not possible:

Is there a way to always allow macros for me (=when I open them) ?

Jeff