Excel Macro Security Level

You can't turn off the security using a macro, but you maybe able to use a digitally signed certificate.
In the Excel Help file type:
create your own digital certificate.

"High You can run only macros that have been digitally signed and that you confirm are from a trusted source. Before trusting a source, confirm that the source is responsible and uses a virus scanner before signing macros. Unsigned macros are automatically disabled and the workbook opens automatically."

The MS article is:
(Type the Q number in the search box at support.microsoft.com)

Overview of Digital Certificates

Q206637

Go to:
http://www.microsoft.com/technet/default.asp
and type digital certificate

This from the Help file:"Create your own digital certificate
Run the Office 2000 setup program.

On the Select Features screen in the setup program, expand Office Tools.

Select Digital Signature for VBA projects, click the arrow next to your selection, and then select Run from My Computer.

In Windows Explorer, locate and then double-click the file SelfCert.exe in
C:\Program Files\Microsoft Office\Office.
Note Because a digital certificate that you create yourself isn?t issued by a formal certificationauthority, macro projects that are signed by using such a certificate are referred to as self-signed projects. Depending on how your organization uses the digital-signature features in Microsoft Office, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons."

This question was closed by the author