Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Locked Form with Linked Spreadsheet
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! -- MB |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Locked Form with Linked Spreadsheet
Hi MB,
Yes, you can do this. Simply insert a section break before the linked worksheet and protect only the previous section(s). Cheers "MB" wrote in message ... 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! -- MB |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Locked Form with Linked Spreadsheet
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! -- MB "macropod" wrote: Hi MB, Yes, you can do this. Simply insert a section break before the linked worksheet and protect only the previous section(s). Cheers "MB" wrote in message ... 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! -- MB |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Locked Form with Linked Spreadsheet
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 See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "MB" wrote in message ... 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! -- MB "macropod" wrote: Hi MB, Yes, you can do this. Simply insert a section break before the linked worksheet and protect only the previous section(s). Cheers "MB" wrote in message ... 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! -- MB |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel spreadsheet in locked Word form | Microsoft Word Help | |||
Merging data into a locked form? | Page Layout | |||
spell checking a locked form | Microsoft Word Help | |||
Is it possible to follow a hyperlink in a locked Word form? | Microsoft Word Help | |||
How can I spellcheck the text entered into a locked form? | Microsoft Word Help |