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...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=515269

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
"Alec H" wrote in
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...o&userid=31042
| View this thread: http://www.excelforum.com/showthread...hreadid=515269
|

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.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=515269

You may want to read excel's help for digital signatures.

Alec H wrote:

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.

--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=515269

--

Dave Peterson

Dave,

Digital signature solved the problem,

Thanks


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=515269