'Buttons' on a Locked Word Form

[Ken Curtis]

I have generated many forms for our Agency (Social Services), most of which
have text fields and other tools. Obviously, after the form is created it
needs to be locked (and password protected) to enable the text fields, and to
maintain the integrety of the form.
On one of the forms (I am trying to build it now) I have embedded (linked)
part of an Excel spreadsheet. When the form is 'unlocked', then double
clicking on this segmant of the spreadsheet opens the entire spreadsheet in
Excel, people fill in the spreadsheet, save it, shut it down ... and it
updates the portion that is showing on the Word 'form'. However, when the
form is locked, I cannot double click on the form to open the spreadsheet.
Now, I understand that what I could do is have people go to Excel, open the
spreadsheet, fill it in .... bla, bla. However, what I want to do is put a
button on the form itself which, when clicked / pressed, follows a hyperlink
to the spreadsheet. In Access this is easy; apparently not so easy in word:
When I lock the form, the 'button' does not work ... at least so far.

Ideas?

 

[Doug Robbins - Word MVP]

See the article "Using MacroButton fields†at:

http://www.word.mvps.org/FAQs/TblsFldsFms/UsingMacroButton.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[macropod]

Hi Ken,

To enable opening of the spreadsheet, simply put Section breaks either side of it (making sure the spreadsheet is anchored between
these two Section breaks), then leave that Section unprotected when protecting the form. You users will now be able to double-click
on the spreadsheet toopen it.