General discussion

Locked

Excel Macro Security Level

By carquiza ·
A question for all VBA and VB user how can I run send an excel file with a macro that automatically change his security setting to low.
Is there a function? or the prompt message regarding macro won't appear having it always says this macro will besafe for virus. Hope this make sense and can a VBA macro on excel run on VB. Need an info. Thanks.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Macro Security Level

by DKlippert In reply to Excel Macro Security Leve ...

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."

Collapse -

Excel Macro Security Level

by carquiza In reply to Excel Macro Security Leve ...

Hi DKlippert,

How to make this digitally signed in Excel? Need more info.
Thanks.

Mel Arquiza
Home Page Design
http://hpd.welcome.to

Collapse -

Excel Macro Security Level

by DKlippert In reply to Excel Macro Security Leve ...

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."

Collapse -

Excel Macro Security Level

by carquiza In reply to Excel Macro Security Leve ...

Hi DKlippert,

Thank you for the information. This is a great help.

Cheers,
Mel Arquiza
Home Page Design
http://hpd.welcome.to

Collapse -

Excel Macro Security Level

by carquiza In reply to Excel Macro Security Leve ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums