View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 1
Default How to permanently activate Macros?

What version of Word/Excel are you using? In Office 2007, you can designate
certain folders as "trusted locations". Hence, any files in those folders
are automatically trusted. Some Office 2003 applications also support the
trusted locations idea, but control is much less direct. See this article
for more information:

http://msdn2.microsoft.com/en-us/library/aa195576.aspx

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Jeff Korn" wrote in message
...
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