disable macro startup prompt

[Guest]

How do I eliminate the startup prompt regarding macros?

 

[Frank Kabel]

Hi
as this is a security feature you may set the security level to 'Low'.
But I wouldn't recommend this

 

[Guest]

If you have deleted the macro, you have to delete the module containing it.
1. Press ALT+F11, to to VBE
2. Find your workbook on the lefthand side (Project Explorer), find the
module that used to contain the deleted macro.
3. Right-click on the module, select "Remove" and when it asks for
exporting, say "No".

Connie

 

[Gord Dibben]

1. Does your workbook contain macros and you want to stop the message?

2. Does your workbook not contain macros and you want to stop the message?

To resolve 2. see Connie's posting.

To resolve 1.

Before setting my security to "low" and running the risk of virus infection, I
would investigate the use of a "digital certificate".

If file is for your use only, check out "self cert" in Help.

You can run Self Cert from the Start>Programs>MS Office>MS Office Tools

Then see Help on "certificates" and "add a digital certificate to a file or
VBA project".

Gord Dibben Excel MVP