Embed link (or attachment) in locked-for-forms document?

[Megan]

I want to provide my users with a) an email link and b) an icon to
double-click that opens an (editable) Excel spreadsheet. (We use this
spreadsheet to collect additional information.) I want to do this on a

document that is locked for forms.

Word does not seem to support this functionality. Does anyone know
otherwise, or know of any workarounds? (I read somewhere that it is
possible to lock portions of a document, but that is only true when you

lock for comments or read only - not when you lock for forms.)


Any help greatly appreciated!

 

[Robert M. Franz (RMF)]

Hi Megan

I want to provide my users with a) an email link and b) an icon to
double-click that opens an (editable) Excel spreadsheet. (We use this
spreadsheet to collect additional information.) I want to do this on a

document that is locked for forms.

Word does not seem to support this functionality. Does anyone know
otherwise, or know of any workarounds? (I read somewhere that it is
possible to lock portions of a document, but that is only true when you

lock for comments or read only - not when you lock for forms.)

The usual road to achieve this is by a macro which unlocks the form,
does what you want, and relocks it again.

A couple of articles on the mvp site discuss this:

http://word.mvps.org/FAQs/TblsFldsFms/index.htm

Greetinx
Robert

 

[Cindy M.]

Hi Megan,

I want to provide my users with a) an email link and b) an icon to
double-click that opens an (editable) Excel spreadsheet. (We use this
spreadsheet to collect additional information.) I want to do this on a

document that is locked for forms.

Word does not seem to support this functionality. Does anyone know
otherwise, or know of any workarounds? (I read somewhere that it is
possible to lock portions of a document, but that is only true when you

lock for comments or read only - not when you lock for forms.)

No, it's also true for forms. Insert a section break before and after the
range that should be unprotected. As soon as the document contains more
than the one default section, you should see an option for "Sections" in
whichever interface you're using (unfortunately, you don't mention which
version of Word is involved, here). In the dialog box you can specify
which sections should be protected/unprotected.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail