Rachael wrote:
I have read through most of the prior postings regarding this, and
followed the instructions on this document:
http://word.mvps.org/FAQs/TblsFldsFms/HLinksInForms.htm
However, when I double-click the link in my re-protected form, after
creating the macro, it only takes me to the next field on the form,
rather than to the Excel spreadsheet is linked to.
Can someone please help me figure out what I'm doing wrong?
Add the AutoExec macro (under the "Double-click or single-click" heading in
the article) to your template, so you can single-click the link.
The problem is that when you have to double-click the MacroButton field, the
first of the two clicks forces the cursor out of the protected area and into
the next form field. The second click never takes effect. (This may have
worked differently in an earlier version of Word, or when computers were a
bit slower.)
You can ignore the discussion of the DocumentChange event that follows the
AutoExec macro. I don't see any point in having some documents respond to
single clicks and others to double clicks.
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ:
http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.