Hyperlink in a protected form

[Guest]

I have a form I created and within that form I have someone's email address.
I have protected the form so that parties completing it will only be able to
edit the grey areas or check inside check boxes. Initially I had to add a
macro (follow link) so that the email address was accessible. I added the
macro to the document. when I email this document to someone protected -
they cannot initiate an email by clicking on the address. now he is getting
a macro error. Any suggestions? Thanks!

 

[Jay Freedman]

Assuming you did put the macro in the document itself, and not in the
template on which the document was based...

Tell the recipient to go to the Tools > Macro > Security dialog and set the
security level to Medium. Then re-open the form document, and click the
Enable button in the macro warning box that appears.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

The only problem is that it is going out to a number of people. Do i tell
them all that they have to change their security level?

Thanks for responding. What I am trying to do is an electronic pledge card
for my church. so i have check boxes for levels of giving and grey text
boxes for names, addresses, etc. Ultimately, I want them be able to email it
back to the treasurer. Do you have any other ideas?

 

[Guest]

I couldnt tell if I posted my reply correctly.... can you let me know if you
received it. Thanks again.

 

[Jay Freedman]

The setup using a MacroButton field for the hyperlink and a macro to
follow it is a Catch-22 situation. If you want the hyperlink to work,
you need the macro. If you want the macro to work, you need to have a
security level no higher than Medium.

Fortunately, there is a better solution. Place the plain vanilla
hyperlink in the document, without the MacroButton field, and insert a
continuous-type section break before and after the hyperlink (or just
one before, if the hyperlink is at the end of the document).

Open the Protect Document task pane (the lock icon on the Forms
toolbar won't do). When you select protection for forms, you should
see a blue link "Select sections..." below the dropdown; click that
and uncheck the section that contains the hyperlink. Now that
hyperlink will operate without the macro. In the VBA editor, delete
the module that contains the macro.

Test this by sending a copy to another computer where the macro
security level is High. If it complains about the macro even though it
was deleted, save the document as RTF and then open the RTF file and
save it back to .doc format; that'll clean out the remains of the
macro.

 

[Guest]

I am very impressed! thank you so very much. how do you know all this?????

 

[Guest]

One more question if i could.....

now you need to hit the ctrl key and click on the email address to initiate
an email. is there a way to eliminate that?

 

[Suzanne S. Barnhill]

No, this is dependent on the Options setting on the recipient's system. The
only way you could change that would be with a macro, and you'd be back to
square one (and the recipient might be very unhappy as well).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.