Macro Security Dialog - Document has no macros
 

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.

Macro Security Dialog - Document has no macros
 

"Jon Robertson" wrote in
message ...
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.


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

Macro Security Dialog - Document has no macros
 

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.

--
Regards,
Tom Ogilvy

"Jon Robertson" wrote in message
...
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.

Macro Security Dialog - Document has no macros
 

And if you want to see pictures, you can visit Debra Dalgleish's site:

http://www.contextures.com/xlfaqMac.html#NoMacros

Jon Robertson wrote:

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.

--

Dave Peterson