Re: Macro Xcel Windows

From: Gord Dibben (gorddibbATshawDOTca)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 10:11:40 -0800

Kyle

If using XL97, macro security is on or off, no levels. If using newer version
of Excel have a look at the following.

Before setting your security to "low" which will let every file with macros
open without warning I would investigate the use of Office's Self
Certification tool.

You can create a digital certificate and use that on your VBAProject so only
that file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digitasl Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.
OK your way out and save your file. You will repeat this step for each
workbook that contains macros.

Next time you open this/these particular file(s) you will not get the warning.

Gord Dibben Excel MVP

On Mon, 16 Feb 2004 22:50:39 +1100, "Norman Harker" <njharker@optusnet.com.au>
wrote:

>Hi Kyle!
>
>Re-read the warning as you have it wrong.
>
>You can prevent this warning popping up by changing your security
>settings.
>
>Tools > Macro > Security
>re-set to "Low"
>
>But make sure that you have:
>
>1. Installed an anti virus program
>2. That your virus definitions are up to date
>3. The you have installed all updates / patches to your Operating
>System and Office
>4. That you regularly check for updates to viruses and updates
>5. That you and other users of the computer don't open attachments to
>emails or click hyperlinks in emails without scanning them (even if
>they are from someone you know).
>6. ...Watch this space!!!

Relevant Pages

  • Re: self-signing certificate
    ... saw that my self-signed certificate was under the ... Now warnings at all when opening with medium security set. ... And, if correct, why the warning? ...
    (microsoft.public.access.security)
  • Re: Macros, XP
    ... If the warning message suggests that security is set high and macros ... Set the macro security to medium, which provides the option of running ... >> Office 97 due to my work environment that I haven't taken the time ...
    (microsoft.public.word.newusers)
  • Re: Word forms and security issues
    ... If you use only form fields combined with macros, ... For that you need a digital certificate, ... certificate will open without prompts regardless of the security level. ... But are those issues only for form controls that use activex? ...
    (microsoft.public.word.docmanagement)
  • macros with expired or revoked signature
    ... Thank you for your help but if I set Security to Medium ... >which means that no macros will be enabled. ... You will now get a warning ...
    (microsoft.public.word.application.errors)
  • Web server SSL certificate not quite right
    ... service under .NET Server 2003 RC1. ... there is a problem with the site's security certificate. ... Anyone have any details on how to get rid of the warning? ...
    (microsoft.public.dotnet.framework.aspnet.security)
Loading