Prev: Selecting text inside a cell
Next: Paragraph formating jumps to defaults.
From: Gordon Bentley-Mix on 26 Apr 2010 00:03
I know this has been asked before, but because I was *so sure* I knew the
answer I never bothered to read any of the posts thoroughly enough to commit
it to memory. Bad move on my part. I'm apparently not as smart as I thought
I was. ;-P

I have a template that contains macros (a couple of code modules and several
UserForms). I now want to use this template differently and no longer need
the code in it. I've removed everything through the VBE and even gone so far
as to save it as .rtf and back as .dot again. Unfortunately, I still get the
macro security warning when I open it or create a new document from it using
standard Word functionality. (Oddly enough, the new method for using this
template involves creating a document from it programmatically, and this
process doesn't invoke the security warning...)

So what else do I need to do to convince Word that this template actually
doesn't contain macros anymore? Or would I be better off just creating the
template from a new blank document? (I'd rather not as duplicating the
formatting is going to be a PITA.)
--
Cheers!

Gordon Bentley-Mix

From: Doug Robbins - Word MVP on 26 Apr 2010 02:41
How about importing the content of the template into a new blank document?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Gordon Bentley-Mix" <gordon(a)NOSPAM.exmvps.org> wrote in message
news:B098C174-26C0-4CFE-8810-251EC0FE42C2(a)microsoft.com...
> I know this has been asked before, but because I was *so sure* I knew the
> answer I never bothered to read any of the posts thoroughly enough to
> commit it to memory. Bad move on my part. I'm apparently not as smart as I
> thought I was. ;-P
>
> I have a template that contains macros (a couple of code modules and
> several UserForms). I now want to use this template differently and no
> longer need the code in it. I've removed everything through the VBE and
> even gone so far as to save it as .rtf and back as .dot again.
> Unfortunately, I still get the macro security warning when I open it or
> create a new document from it using standard Word functionality. (Oddly
> enough, the new method for using this template involves creating a
> document from it programmatically, and this process doesn't invoke the
> security warning...)
>
> So what else do I need to do to convince Word that this template actually
> doesn't contain macros anymore? Or would I be better off just creating the
> template from a new blank document? (I'd rather not as duplicating the
> formatting is going to be a PITA.)
> --
> Cheers!
>
> Gordon Bentley-Mix

From: Graham Mayor on 26 Apr 2010 03:08
Does the document have activex controls? These will flag a macro security
warning (though not in RTF format - but will do so again if you save back to
Word format)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
..

"Gordon Bentley-Mix" <gordon(a)NOSPAM.exmvps.org> wrote in message
news:B098C174-26C0-4CFE-8810-251EC0FE42C2(a)microsoft.com...
>I know this has been asked before, but because I was *so sure* I knew the
>answer I never bothered to read any of the posts thoroughly enough to
>commit it to memory. Bad move on my part. I'm apparently not as smart as I
>thought I was. ;-P
>
> I have a template that contains macros (a couple of code modules and
> several UserForms). I now want to use this template differently and no
> longer need the code in it. I've removed everything through the VBE and
> even gone so far as to save it as .rtf and back as .dot again.
> Unfortunately, I still get the macro security warning when I open it or
> create a new document from it using standard Word functionality. (Oddly
> enough, the new method for using this template involves creating a
> document from it programmatically, and this process doesn't invoke the
> security warning...)
>
> So what else do I need to do to convince Word that this template actually
> doesn't contain macros anymore? Or would I be better off just creating the
> template from a new blank document? (I'd rather not as duplicating the
> formatting is going to be a PITA.)
> --
> Cheers!
>
> Gordon Bentley-Mix


From: Gordon Bentley-Mix on 26 Apr 2010 17:30
I know this will work, but this is exactly what I don't want to have to do.
The template contains a good deal of complex formatting, and I don't want to
have to go through all of the work of replicating it in a new doc. I know
the Styles will come across automatically, but then there are the headers
and footers and page layout, etc. It seems to me that I should be able to
just remove the code and have the macro security warning go away.
Unfortunately, that doesn't seem to be the case...
--
Cheers!

Gordon Bentley-Mix

"Doug Robbins - Word MVP" <dkr(a)REMOVECAPSmvps.org> wrote in message
news:E479F682-85A9-4AEF-9976-FB1A50AC3515(a)microsoft.com...
> How about importing the content of the template into a new blank document?
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
>
> "Gordon Bentley-Mix" <gordon(a)NOSPAM.exmvps.org> wrote in message
> news:B098C174-26C0-4CFE-8810-251EC0FE42C2(a)microsoft.com...
>> I know this has been asked before, but because I was *so sure* I knew the
>> answer I never bothered to read any of the posts thoroughly enough to
>> commit it to memory. Bad move on my part. I'm apparently not as smart as
>> I thought I was. ;-P
>>
>> I have a template that contains macros (a couple of code modules and
>> several UserForms). I now want to use this template differently and no
>> longer need the code in it. I've removed everything through the VBE and
>> even gone so far as to save it as .rtf and back as .dot again.
>> Unfortunately, I still get the macro security warning when I open it or
>> create a new document from it using standard Word functionality. (Oddly
>> enough, the new method for using this template involves creating a
>> document from it programmatically, and this process doesn't invoke the
>> security warning...)
>>
>> So what else do I need to do to convince Word that this template actually
>> doesn't contain macros anymore? Or would I be better off just creating
>> the template from a new blank document? (I'd rather not as duplicating
>> the formatting is going to be a PITA.)
>> --
>> Cheers!
>>
>> Gordon Bentley-Mix
>
From: Gordon Bentley-Mix on 26 Apr 2010 17:31
Nope. No ActiveX controls. Not even form fields. Just bookmarks in the body
of the template and the code modules and UserForms mentioned below.
--
Cheers!

Gordon Bentley-Mix

"Graham Mayor" <gmayor(a)REMOVETHISmvps.org> wrote in message
news:#06658Q5KHA.1932(a)TK2MSFTNGP05.phx.gbl...
> Does the document have activex controls? These will flag a macro security
> warning (though not in RTF format - but will do so again if you save back
> to Word format)
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> .
>
> "Gordon Bentley-Mix" <gordon(a)NOSPAM.exmvps.org> wrote in message
> news:B098C174-26C0-4CFE-8810-251EC0FE42C2(a)microsoft.com...
>>I know this has been asked before, but because I was *so sure* I knew the
>>answer I never bothered to read any of the posts thoroughly enough to
>>commit it to memory. Bad move on my part. I'm apparently not as smart as I
>>thought I was. ;-P
>>
>> I have a template that contains macros (a couple of code modules and
>> several UserForms). I now want to use this template differently and no
>> longer need the code in it. I've removed everything through the VBE and
>> even gone so far as to save it as .rtf and back as .dot again.
>> Unfortunately, I still get the macro security warning when I open it or
>> create a new document from it using standard Word functionality. (Oddly
>> enough, the new method for using this template involves creating a
>> document from it programmatically, and this process doesn't invoke the
>> security warning...)
>>
>> So what else do I need to do to convince Word that this template actually
>> doesn't contain macros anymore? Or would I be better off just creating
>> the template from a new blank document? (I'd rather not as duplicating
>> the formatting is going to be a PITA.)
>> --
>> Cheers!
>>
>> Gordon Bentley-Mix
>
>
 |  Next  |  Last
Pages: 1 2
Prev: Selecting text inside a cell
Next: Paragraph formating jumps to defaults.