Form Protection with Excel Object Embedded
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hi,
I am using Office XP (Word). I created a form which embeds an excel object
file.
When it is unprotected, I am able to double-click the excel file change a
cell, and another cell recalculates appropriately.
When I protect the document, I am not able to access the excel object at all
to change it - it is skipped right over when tabbed to.
The excel recalculation cell goes beyond the normal arithmetic functions of
the Word Formulas in Tables, so I can't use those (it is a date calculation).
The only way around it so far that I see is to separate the form into
sections, where the excel table is on its own line, unprotected in its own
section. Is there a way to do it without unprotecting the line?
Thanks in advance for all your help!
--
Debbie
.
Relevant Pages
- Re: populate a word table programatically
... How does a LINK field work? ... That's because the forms protection ... Unprotecting & reprotecting the document is fairly straightforward. ... The code will be in an Excel wbk that the user will have open, ...
(microsoft.public.word.tables) - Re: populate a word table programatically
... Another thing you'll have to deal with on the Word side, is unprotecting the document before populating the table, then reprotecting the document again afterwards. ... That's because the forms protection won't allow you to edit the protected portion of the document. ... Since you're working with a document protected for forms, and you apparently want to import some data from an Excel workbook, have you thought of using a LINK field and just updating the field's source range to suit the user's input in a given formfield? ...
(microsoft.public.word.tables) - Re: Form Protection with Excel Object Embedded
... Thank you, Macropod. ... Word Date Calculation Tutorial, at: ... I created a form which embeds an excel object ... Is there a way to do it without unprotecting the line? ...
(microsoft.public.word.application.errors) - Re: saving SELECT results to excel -NEWBIE
... Before I go trotting down excel object lane, let me clarify, ... query 2 total goes in 2nd cell, ... Does it still sound as if I need excel object model? ... > all over the Excel workbook then DTS is not really your tool. ...
(microsoft.public.sqlserver.dts) - Re: Form Protection with Excel Object Embedded
... If you prefer to retain your Excel workbook, though, insert Section breaks either side of it and leave that Section unprotected when you apply the forms protection. ... cell, ... so I can't use those (it is a date calculation). ... Is there a way to do it without unprotecting the line? ...
(microsoft.public.word.application.errors) |
|
