Help: How to stop macro security warning

[cabezahueco]

I have an excel workbook where at one point in time I had made a simple macro. I then saved the work book, and deleted the macro.

Now everytime i open the workbook I get the security warning message that says macros may contain viruses blah blah blah.. do you want to enable/disable macros?

Is there away that I can prevent this message from popping up without lowering my security levels? (I can't digitally sign any macros because none exist anymore, i deleted them all. in the macro menu/window.)

Thanks,

[raypayette]

Erasing the macro is insufficient, you must delete the module.
Go in VBE, click File, Remove Module1 and click No.

[Clauddvon]

Change your security level to low (not recommended though for the following reasons...unless all your macros are macros that you have created, and you don't download other workbooks with pre-existing macros.) If you do...Medium or High are the best answer because (as per Help file):

The macro might not be from a trusted source If the security level is set to Medium or High and you open a workbook or load an add-in program that contains digitally signed macros that are not from a trusted source, you receive a macro warning. If you are sure that you trust the macro developer, add the name to the list of trusted sources.

The macro might contain a virus If you don't expect a workbook to contain a macro, you might have a virus that is adding a macro virus to the workbook. Check your computer for viruses and then try to get an uninfected copy of the workbook from the source.

The macro might be in a temporary file that you downloaded from a Web site If your virus scanner tells you that it has removed a virus in this file every time you open it, you are removing the virus from the temporary file only and not from the original file on the Web server. Check your computer for viruses and then notify the source about problems with the original file.

The workbook may contain legitimate macros Excel cannot distinguish between safe and unsafe macros. If you know that these are legitimate and safe macros, you might want to digitally sign the macros and add your name to the list of trusted sources.