Prev: Selecting variable amount of text in Word 2007 macro/VBA
Next: Why can't ranges be moved by wdLine?
From: JonnyB on 17 Feb 2010 03:20
Hi Richard

All macros are attached to the document.dot.

"Richard" wrote:

> Hi
>
> Are a couple of the macros in the Normal.dot rather than in your document.dot?
>
> If so, they will work fine on your computer, but not on someone elses.
>
>
> --
> Richard
>
>
> "JonnyB" wrote:
>
> > Thanks anyway Graham.
> >
> > "Graham Mayor" wrote:
> >
> > > In that case I can't account for the behaviour.
> > >
> > > --
> > > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > > 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:28385807-9E2F-47E8-9519-8D85704DF134(a)microsoft.com...
> > > > 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
> > > >> >> >
> > > >> >>
> > > >> >>
> > > >> >> .
> > > >> >>
> > > >>
> > > >>
> > > >> .
> > > >>
> > >
> > >
> > > .
> > >
From: JonnyB on 17 Feb 2010 03:21
Hi

Yes, thta's what I mean.

Thanks

"Fumei2 via OfficeKB.com" wrote:

> Also, could you clarify: "few of the macros don't appear in the form fields"
>
> macros in the formfields? Do you mean as OnExit/OnEntry macros?
>
> Macros do not appear in formfields.
>
> Richard wrote:
> >Hi
> >
> >Are a couple of the macros in the Normal.dot rather than in your document.dot?
> >
> >If so, they will work fine on your computer, but not on someone elses.
> >
> >> Thanks anyway Graham.
> >>
> >[quoted text clipped - 82 lines]
> >> >
> >> > .
>
> --
> Message posted via http://www.officekb.com
>
> .
>
From: JonnyB on 17 Feb 2010 03:26
Hi

After transmission some macros do not appear in on Entry/Exit on the form
fileds property pop up box. However, the forms work as intended before
transmission. However, after once entering the VBA editor and changing, for
example a calculation on exit, those form fields that have "lost the link to
the macro" thereafter stop working.

Thanks

"Fumei2 via OfficeKB.com" wrote:

> " 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.
> "
>
> I am trying to follow this. You now have formfields that do NOT have an
> OnEntry or OnExit macro, and when you "edit" them - what does that mean
> exactly??? - OTHER macros no longer work?
>
> Fumei2 wrote:
> >Also, could you clarify: "few of the macros don't appear in the form fields"
> >
> >macros in the formfields? Do you mean as OnExit/OnEntry macros?
> >
> >Macros do not appear in formfields.
> >
> >>Hi
> >>
> >[quoted text clipped - 7 lines]
> >>> >
> >>> > .
>
> --
> Message posted via http://www.officekb.com
>
> .
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Selecting variable amount of text in Word 2007 macro/VBA
Next: Why can't ranges be moved by wdLine?