General discussion

  • Creator
    Topic
  • #2323082

    Excel Macro Security Level

    Locked

    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.

All Comments

  • Author
    Replies
    • #3405666

      Excel Macro Security Level

      by dklippert ·

      In reply to 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.”

    • #3402736

      Excel Macro Security Level

      by dklippert ·

      In reply to Excel Macro Security Level

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

    • #3593459

      Excel Macro Security Level

      by carquiza ·

      In reply to Excel Macro Security Level

      This question was closed by the author

Viewing 2 reply threads