Locked Form with Linked Spreadsheet

M

MB

Good day, experts!

I created a form that is linked to an Excel spreadsheet. The spreadsheet is
the second page of the form. The first page consists of the various fields
which the user fills in. When I lock the form, I cannot launch the
spreadsheet by double-clicking on it. Is there a way to unlock the second
page or allow the linked file to be opened when the form is locked?

I am using version 2003.

Thank you!
 
M

macropod

Hi MB,

Yes, you can do this. Simply insert a section break before the linked
worksheet and protect only the previous section(s).

Cheers
 
M

MB

Thank you for your reply. I added the section break (next page), but am lost
how to protect just that first section. If you have a moment, could you
please give me the next steps?

Again, thanks so much. Your expertise is greatly appreciated!
 
C

Charles Kenyon

Tools > Protect Document
instead of just clicking on the lock button.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
Top