how to avoid macro warning dialog box????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to disable or avoid from appearing the excel macro information dialog box with button
disable, enable and more info? the description in the dialog box says macros may contain viruses. it is always safe to disable macros, but if the macros are.......................

pls help me. is there a way to avoid this warning dialog box???
 
You don't say which version of Excel you are running.

If 97 macro warning is on or off. Your choice in Tools>Options>General.

With 2000 and newer there are 3 security levels under Tools>Options>Security.

High which won't allow macros to run.

Medium which will give the warning.

Low which allows everything to run.

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.

Next time you open this particular file you will not get the warning.

Gord Dibben Excel MVP
 
dear gord dibben

in the security, how should i put in the trusted sources after i run the selfcert.exe as it still unable to take effect when i put high security
pls help
 
Your self-cert name should show up in the list at Tools>Options>Security>Macro
Security>Trusted Sources.

The first time you open your workbook with the certificate checked in VBE
Tools>Digital Certificates you will get a warning. Click on "always trust
etc".

For more on trouble-shooting this subject see the Help Wizard "trusted
sources"(no quotes).

Gord Dibben Excel MVP
 
dear fren
i got another problem. how to enforce user that macro must run even if the security level is medium. when user choose disable then the worksheet will not come out. only when they click enable the worksheet can come out with macro loaded. is there a way to do so
thank
 
I believe you also posted this under the name of "help" about 30 minutes ago.

See one possible answer there.

Gord Dibben Excel MVP
 
Back
Top