Re: Form Protection with Excel Object Embedded

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thank you, Macropod. I downloaded your document and read it head-to-toe (and
it was excellent!) It appears that one of the examples is close to what I
would like, but not exactly.

Basically, what I am trying to do is to calculate the #Years & #Months
between a birthdate and an inputted date, and have it give me an answer in
decimal format. For example, if someone is 12 years 6 months old (regardless
of # of days), I want it to say 12.5 years (.5 equalling 6 months). So 12
years and 8 months would be 12.6 (rounded down or up is fine). I don't need
absolute exactness.

I don't know whether to use a version of "Interactively Calculating a
Person's Age" (it will not be interactive, but input on a form), or
"Calculate the # Years Months & Days Difference Between Two Dates".

I am unsure as to the format of the input date as well. Does it need to be
d M yyyy or is mm-dd-yyyy or another other format okay? If I accept another
format, do I need to first reformat it to be accepted in the calculation?

One more thing - about section breaks in case the above doesn't work in the
end. It appears when I put a section break right after a field in a Word
document, it automatically extends to the end of the line and forces the next
field (or text) to the next line. I am using
Insert->Break->Section->Continuous. Based on what you are saying, that
should not happen - I should be able to "wrap" protected areas around
unprotected areas. How do you do this?

Thanks so much for your time!
--
Debbie


"macropod" wrote:

Hi Debbie,

Word can do date calculations! To see how to do just about everything else you might want to do with dates in Word, check out my
Word Date Calculation Tutorial, at:
http://www.wopr.com/index.php?showtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party
Do read the document's introductory material.

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.

--
Cheers
macropod
[Microsoft MVP - Word]


"Debbie" <Debbie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:564423A9-7C8B-4146-8323-D46033BDF49E@xxxxxxxxxxxxxxxx
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: Form Protection with Excel Object Embedded
    ... "macropod" wrote: ... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via ... If you prefer to retain your Excel workbook, though, insert Section breaks either side of it and leave that Section ...
    (microsoft.public.word.application.errors)
  • Re: Form Protection with Excel Object Embedded
    ... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days Difference ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via the ... If you prefer to retain your Excel workbook, though, insert Section breaks either side of it and leave that Section unprotected ... Is there a way to do it without unprotecting the line? ...
    (microsoft.public.word.application.errors)
  • Re: Form Protection with Excel Object Embedded
    ... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days Difference Between Two Dates'. ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via the formfield properties. ... You should be able to insert one immediately before & after the Excel workbook, ... Is there a way to do it without unprotecting the line? ...
    (microsoft.public.word.application.errors)
  • 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)
  • Re: How can I change the default manual calculation as automatic
    ... Private Sub Workbook_Open ... > Hi macropod ... >>> excel can do the calculation automatically. ...
    (microsoft.public.excel.misc)