Macro message

A

Alec H

Hi,

I have produced a workbook that contains multiple macros that is shared
via a server to several users.

When any of the users open the workbook it throws up the standard
microsoft message asking if the user wants to "enable" macros or not.
To avoid confusion to the users, I want to turn off this message and
automatically enable macros........

Help please. :)
 
J

Jim Rech

I want to turn off this message

Not possible. This is designed as protection against macro viruses. It
would not be effective if the virus writer could turn it off.

--
Jim
message |
| Hi,
|
| I have produced a workbook that contains multiple macros that is shared
| via a server to several users.
|
| When any of the users open the workbook it throws up the standard
| microsoft message asking if the user wants to "enable" macros or not.
| To avoid confusion to the users, I want to turn off this message and
| automatically enable macros........
|
| Help please. :)
|
|
| --
| Alec H
| ------------------------------------------------------------------------
| Alec H's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=31042
| View this thread: http://www.excelforum.com/showthread.php?threadid=515269
|
 
A

Alec H

Jim,

I understand the security aspects, but as this workbook is being used
in a secure environment is there no "Always trust......." type
workaround that I can use, even if the user has to select this the
first time they open the file?

Alec.
 
Top