Prev: Selecting variable amount of text in Word 2007 macro/VBA
Next: Why can't ranges be moved by wdLine?
From: JonnyB on 15 Feb 2010 06:05
Hi All

I would be very grateful for a little guidance over an issue that is
puzzling me. I have a template with a number of macros attached. When I send
the template by email to my co-worker, some of the macros don't appear on the
form field's "Run macro on Entry or Exit". The macros do appear, however, in
the Visual Basic editor.

The template works perfectly well, until it is unprotected an edited.
Thereafter, those form field that have "lost" the macro name/limk from their
form fields don't work anymore. So, as long as the macros in the template are
not edited, the template continues to work as designed. However, this is very
frustrating since my co-worker (who lives far from me) will require to edit
these macros as forms are developed further.

I would be so grateful for any assistance: I am tearing my hair out over
this issue.

Thanks William

From: Graham Mayor on 15 Feb 2010 06:46
What Word version is this?
Are you saving the macros in the document, or in the template associated
with the document.
If the document and it is Word 2007 are you saving as DOTM, if Word 2003 or
earlier, what is the macro security setting.
If the template is it in a trusted location - or again what is the macro
security setting?
Save this form and the macros associated with it as a template (DOT or DOTM)
and supply the template to your colleague.

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

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



"JonnyB" <JonnyB(a)discussions.microsoft.com> wrote in message
news:52E774F4-146B-4339-AF9D-EED2DE567426(a)microsoft.com...
> Hi All
>
> I would be very grateful for a little guidance over an issue that is
> puzzling me. I have a template with a number of macros attached. When I
> send
> the template by email to my co-worker, some of the macros don't appear on
> the
> form field's "Run macro on Entry or Exit". The macros do appear, however,
> in
> the Visual Basic editor.
>
> The template works perfectly well, until it is unprotected an edited.
> Thereafter, those form field that have "lost" the macro name/limk from
> their
> form fields don't work anymore. So, as long as the macros in the template
> are
> not edited, the template continues to work as designed. However, this is
> very
> frustrating since my co-worker (who lives far from me) will require to
> edit
> these macros as forms are developed further.
>
> I would be so grateful for any assistance: I am tearing my hair out over
> this issue.
>
> Thanks William
>


From: JonnyB on 15 Feb 2010 07:49
Hi Graham

Thanks for your response. In answer to your questions we are using Word
2003, the document is tranmitted at a template with macros attached and the
security setting is set to medium.

As I said in my original question, the template and documents based on this
template work perfectly well until the macros are edited and then those with
the "missing link" stop working.



"Graham Mayor" wrote:

> What Word version is this?
> Are you saving the macros in the document, or in the template associated
> with the document.
> If the document and it is Word 2007 are you saving as DOTM, if Word 2003 or
> earlier, what is the macro security setting.
> If the template is it in a trusted location - or again what is the macro
> security setting?
> Save this form and the macros associated with it as a template (DOT or DOTM)
> and supply the template to your colleague.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
>
> "JonnyB" <JonnyB(a)discussions.microsoft.com> wrote in message
> news:52E774F4-146B-4339-AF9D-EED2DE567426(a)microsoft.com...
> > Hi All
> >
> > I would be very grateful for a little guidance over an issue that is
> > puzzling me. I have a template with a number of macros attached. When I
> > send
> > the template by email to my co-worker, some of the macros don't appear on
> > the
> > form field's "Run macro on Entry or Exit". The macros do appear, however,
> > in
> > the Visual Basic editor.
> >
> > The template works perfectly well, until it is unprotected an edited.
> > Thereafter, those form field that have "lost" the macro name/limk from
> > their
> > form fields don't work anymore. So, as long as the macros in the template
> > are
> > not edited, the template continues to work as designed. However, this is
> > very
> > frustrating since my co-worker (who lives far from me) will require to
> > edit
> > these macros as forms are developed further.
> >
> > I would be so grateful for any assistance: I am tearing my hair out over
> > this issue.
> >
> > Thanks William
> >
>
>
> .
>
From: Graham Mayor on 15 Feb 2010 08:53
In what way are you changing the macros. Are you changing the macro names as
that would unlink them from the fields.

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

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


"JonnyB" <JonnyB(a)discussions.microsoft.com> wrote in message
news:C36DA2BE-FB30-45FE-8DFA-199C564E4DDD(a)microsoft.com...
> Hi Graham
>
> Thanks for your response. In answer to your questions we are using Word
> 2003, the document is tranmitted at a template with macros attached and
> the
> security setting is set to medium.
>
> As I said in my original question, the template and documents based on
> this
> template work perfectly well until the macros are edited and then those
> with
> the "missing link" stop working.
>
>
>
> "Graham Mayor" wrote:
>
>> What Word version is this?
>> Are you saving the macros in the document, or in the template associated
>> with the document.
>> If the document and it is Word 2007 are you saving as DOTM, if Word 2003
>> or
>> earlier, what is the macro security setting.
>> If the template is it in a trusted location - or again what is the macro
>> security setting?
>> Save this form and the macros associated with it as a template (DOT or
>> DOTM)
>> and supply the template to your colleague.
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>>
>> "JonnyB" <JonnyB(a)discussions.microsoft.com> wrote in message
>> news:52E774F4-146B-4339-AF9D-EED2DE567426(a)microsoft.com...
>> > Hi All
>> >
>> > I would be very grateful for a little guidance over an issue that is
>> > puzzling me. I have a template with a number of macros attached. When I
>> > send
>> > the template by email to my co-worker, some of the macros don't appear
>> > on
>> > the
>> > form field's "Run macro on Entry or Exit". The macros do appear,
>> > however,
>> > in
>> > the Visual Basic editor.
>> >
>> > The template works perfectly well, until it is unprotected an edited.
>> > Thereafter, those form field that have "lost" the macro name/limk from
>> > their
>> > form fields don't work anymore. So, as long as the macros in the
>> > template
>> > are
>> > not edited, the template continues to work as designed. However, this
>> > is
>> > very
>> > frustrating since my co-worker (who lives far from me) will require to
>> > edit
>> > these macros as forms are developed further.
>> >
>> > I would be so grateful for any assistance: I am tearing my hair out
>> > over
>> > this issue.
>> >
>> > Thanks William
>> >
>>
>>
>> .
>>


From: JonnyB on 15 Feb 2010 09:35
No no name changes. After transmitting by email and opening the template a
few of the macros don't appear in the form fields, most do however. The
templates work perfectly well until an edit is made to those fileds that do
not have the macro in the Enter and Exit fields in the form filed pop up box.

"Graham Mayor" wrote:

> In what way are you changing the macros. Are you changing the macro names as
> that would unlink them from the fields.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> "JonnyB" <JonnyB(a)discussions.microsoft.com> wrote in message
> news:C36DA2BE-FB30-45FE-8DFA-199C564E4DDD(a)microsoft.com...
> > Hi Graham
> >
> > Thanks for your response. In answer to your questions we are using Word
> > 2003, the document is tranmitted at a template with macros attached and
> > the
> > security setting is set to medium.
> >
> > As I said in my original question, the template and documents based on
> > this
> > template work perfectly well until the macros are edited and then those
> > with
> > the "missing link" stop working.
> >
> >
> >
> > "Graham Mayor" wrote:
> >
> >> What Word version is this?
> >> Are you saving the macros in the document, or in the template associated
> >> with the document.
> >> If the document and it is Word 2007 are you saving as DOTM, if Word 2003
> >> or
> >> earlier, what is the macro security setting.
> >> If the template is it in a trusted location - or again what is the macro
> >> security setting?
> >> Save this form and the macros associated with it as a template (DOT or
> >> DOTM)
> >> and supply the template to your colleague.
> >>
> >> --
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> Graham Mayor - Word MVP
> >>
> >> My web site www.gmayor.com
> >> Word MVP web site http://word.mvps.org
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>
> >>
> >>
> >> "JonnyB" <JonnyB(a)discussions.microsoft.com> wrote in message
> >> news:52E774F4-146B-4339-AF9D-EED2DE567426(a)microsoft.com...
> >> > Hi All
> >> >
> >> > I would be very grateful for a little guidance over an issue that is
> >> > puzzling me. I have a template with a number of macros attached. When I
> >> > send
> >> > the template by email to my co-worker, some of the macros don't appear
> >> > on
> >> > the
> >> > form field's "Run macro on Entry or Exit". The macros do appear,
> >> > however,
> >> > in
> >> > the Visual Basic editor.
> >> >
> >> > The template works perfectly well, until it is unprotected an edited.
> >> > Thereafter, those form field that have "lost" the macro name/limk from
> >> > their
> >> > form fields don't work anymore. So, as long as the macros in the
> >> > template
> >> > are
> >> > not edited, the template continues to work as designed. However, this
> >> > is
> >> > very
> >> > frustrating since my co-worker (who lives far from me) will require to
> >> > edit
> >> > these macros as forms are developed further.
> >> >
> >> > I would be so grateful for any assistance: I am tearing my hair out
> >> > over
> >> > this issue.
> >> >
> >> > Thanks William
> >> >
> >>
> >>
> >> .
> >>
>
>
> .
>
 |  Next  |  Last
Pages: 1 2 3
Prev: Selecting variable amount of text in Word 2007 macro/VBA
Next: Why can't ranges be moved by wdLine?