software

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 quot;enablequot; 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: www.excelforum.com/member.php...oamp;userid=31042
View this thread: www.excelforum.com/showthread...hreadid=515269gt;gt;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
quot;Alec Hquot; gt; 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 quot;enablequot; 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:
www.excelforum.com/member.php...oamp;userid=31042
| View this thread: 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 quot;Always trust.......quot; 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: www.excelforum.com/member.php...oamp;userid=31042
View this thread: www.excelforum.com/showthread...hreadid=515269You may want to read excel's help for digital signatures.

Alec H wrote:
gt;
gt; Jim,
gt;
gt; I understand the security aspects, but as this workbook is being used
gt; in a secure environment is there no quot;Always trust.......quot; type
gt; workaround that I can use, even if the user has to select this the
gt; first time they open the file?
gt;
gt; Alec.
gt;
gt; --
gt; Alec H
gt; ------------------------------------------------------------------------
gt; Alec H's Profile: www.excelforum.com/member.php...oamp;userid=31042
gt; View this thread: www.excelforum.com/showthread...hreadid=515269

--

Dave Peterson


Dave,

Digital signature solved the problem,

Thanks--
Alec H
------------------------------------------------------------------------
Alec H's Profile: www.excelforum.com/member.php...oamp;userid=31042
View this thread: www.excelforum.com/showthread...hreadid=515269