Isn't that a Catch22? With security set to high, you won't be able to run
VBA code to edit the registry. At any rate, after editing the registry, you
still have to close and reopen Excel to make the security changes effective.

"dominicb" wrote:


Good afternoon Walid M. Bahgat

I believe it is possible - though I haven't actually done it personally
- by editing the registry settings through VBA, the home of the security
setting being :

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

Alternatively, set yourself up with a digital certificate or (if
possible) code your project as an add-in. Either of these two ways will
prevent the macro warning message from appearing.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=468457