When you open a file with macros in medium security you see a dialog box"
Security Warning File x.xls contains macros. Do you want to Disable /
Enable?" You do not see this dialog box for workbooks that have never had a
macro. I created a macro in a workbook and later delete it, but still get the
dialog box, even though no macro is present. Is it possible to turn off the
Security Warning for a workbook after all macros are deleted and still
maintain medium macro security?

Dewy

After deleting the macro(s) you must also delete the module(s) they resided
in.

With the workbook open, hit ALT + F11 to get to the Visual Basic Editor.

CTRL + r to open Project Explorer.

Select your workbook/project and expand it.

Find and right-click on "module1" and Remove Module.

Click "No" when asked if you want to export it.

If you palced any code in worksheets, open them and clear.

Same for Thisworkbook.

Save after and you should lose the message.


Gord Dibben Excel MVP

On Fri, 9 Dec 2005 13:23:02 -0800, "Dewy Cheatum & Howe" <Dewy Cheatum &
wrote:

When you open a file with macros in medium security you see a dialog box"
Security Warning File x.xls contains macros. Do you want to Disable /
Enable?" You do not see this dialog box for workbooks that have never had a
macro. I created a macro in a workbook and later delete it, but still get the
dialog box, even though no macro is present. Is it possible to turn off the
Security Warning for a workbook after all macros are deleted and still
maintain medium macro security?

Thank you Gord. That worked great! Dewy

"Gord Dibben" wrote:

Dewy

After deleting the macro(s) you must also delete the module(s) they resided
in.

With the workbook open, hit ALT + F11 to get to the Visual Basic Editor.

CTRL + r to open Project Explorer.

Select your workbook/project and expand it.

Find and right-click on "module1" and Remove Module.

Click "No" when asked if you want to export it.

If you palced any code in worksheets, open them and clear.

Same for Thisworkbook.

Save after and you should lose the message.


Gord Dibben Excel MVP

On Fri, 9 Dec 2005 13:23:02 -0800, "Dewy Cheatum & Howe" <Dewy Cheatum &
wrote:

When you open a file with macros in medium security you see a dialog box"
Security Warning File x.xls contains macros. Do you want to Disable /
Enable?" You do not see this dialog box for workbooks that have never had a
macro. I created a macro in a workbook and later delete it, but still get the
dialog box, even though no macro is present. Is it possible to turn off the
Security Warning for a workbook after all macros are deleted and still
maintain medium macro security?