Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 15
Default How to permanently activate Macros?

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

  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 5,939
Default How to permanently activate Macros?

Look into digitally signing the projects. There is lots of help on doing that.
--
HTH...

Jim Thomlinson


"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


  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 13
Default How to permanently activate Macros?

Another possible solution, and one personal to you and your machine, go to
Tools, Macros, Security, change the level to one you are comfortable with.
Be aware that you could be leaving yourself vulnerable, say if you are the
sort of person who receives documents from other people that could contain
macros, etc.

Hope this helps
DeanH

"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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to permanently activate Macros? Jeff Korn Excel Discussion (Misc queries) 7 March 11th 08 04:34 PM
how do I create a macro that will activate other macros? sbrigham Excel Programming 3 December 4th 07 10:02 PM
Can a combo box activate different macros Carrie Excel Discussion (Misc queries) 1 June 5th 06 06:34 PM
how to attach macros to excel permanently - pawan Pawan Excel Programming 4 June 21st 05 10:01 AM
Recording macro to activate other macros yippy[_2_] Excel Programming 4 January 6th 04 02:57 PM


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"