Macro Security Dialog - Document has no macros

J

Jon Robertson

I was create a new document template and created macro to help me get
the template created. Once the template was finished, I deleted the
macro.

Now, whenever I open the document (as a template, or new document from
the template), I get the "This document contains macros - Enable /
Disable" security dialog. The document NO LONGER contains macros.
I've checked the Macro dialog box. I've even gone into the Visual
Basic editor and made sure there were NO macros anywhere in the
document.

I don't want to change my security settings, as every member of my team
is using this template. I just want to prevent the dialog from
appearing, since the document no longer contains macros.

Any help would be appreciated.
 
M

Mike

Jon Robertson said:
I was create a new document template and created macro to help me get
the template created. Once the template was finished, I deleted the
macro.

Now, whenever I open the document (as a template, or new document from
the template), I get the "This document contains macros - Enable /
Disable" security dialog. The document NO LONGER contains macros.
I've checked the Macro dialog box. I've even gone into the Visual
Basic editor and made sure there were NO macros anywhere in the
document.

I don't want to change my security settings, as every member of my team
is using this template. I just want to prevent the dialog from
appearing, since the document no longer contains macros.

Any help would be appreciated.
Click to expand...


Jon,

Empty code modules will still cause this dialog box to appear. Did
you remove the module that was created when the macro was recorded?
To remove it, open up the VB editor, right click on the module in the
project explorer and choose Remove Module1 (or whatever it's called).


Hope this helps,

Mike
 
T

Tom Ogilvy

in the VBE, under this project do you see an entry for Module

even if there is not code in the modules, if they exist, they will trigger
this warning. Delete any modules you have listed under Module.


If that still doesn't work or you don't have any, then you need to double
click on each sheet name in the project explorer to expose the sheet module.
Click in it and do Ctrl+a, followed by Delete, then click in the upper right
x to close it.
 
Top