Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Portland, Maine, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Field - macro on exit (Word 2003 SP1)

    I inherited a couple of templates which use form fields. I then have a section break and an unprotected portion of the document. When I exit the last field I want the cursor to move to a certain spot. I created a macro to move to where I want and put the macro into the onexit of the last field. However, I can not get my cursor to go to where I want.

    I know the macro fires because I put a msgbox in it to check. I have tried just moving down. I have tried inserting a bookmark and goto it. I have tried MoveTo end.

    Is there some trick or limitation I just can't figure out

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Field - macro on exit (Word 2003 SP1)

    You've run into a limitation of documents with protected and unprotected sections. An On Exit macro can send the user to another form field within the protected section, but trying to go somewhere in an unprotected section fails.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Portland, Maine, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Field - macro on exit (Word 2003 SP1)

    Thanks for confirming what I thought to be the case

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Field - macro on exit (Word 2003 SP1)

    Does the OnExit macro work if you
    1. unprotect the doc
    2. put the cursor where you want it
    3. protect the doc again?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Field - macro on exit (Word 2003 SP1)

    I hope that works for Darryl, it didn't work for me in Word 2002 SP3 (it was one of the things I tried before I posted my previous reply)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •