Hi,



Got a wee problem, hope someone can help!

Please see the attached word file.

I've created a table inside a word doc, which contains two formulas. Both function perfectly. If I change any of the values in the peach coloured cells, all I have to do is right click / 'update fields' on both grey coloured cells containing the formulas, and it will update the values accordingly.

However, I want users to input their own values into the peach coloured cells without having to right click / 'update fields'. Is there any way the formulas in the grey cells can automatically update after user input? I also want to lock/protect the grey cells so users cannot edit the formulas.

Using excel sadly isn't an option.

any help would be much appreciated.

Thanks..

Attached Files

Customer types.docx (13.9 KB, 8 views)

You could achieve what you're after by using formfields for the data entry in column B, setting their 'calculate on exit' property, then applying forms protection to the document.

I note that you're using SUM(ABOVE) in the last row. You may want to reconsider that, as it is error-prone. For example, if you delete the numbers for 'green' and 'blue', then update the formulae, the last row's result will be wrong. With formfields, you could, of course, specify a numeric format with 0 defaults and that would obviate the problem.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Cross-posted at: http://answers.microsoft.com/en-us/o...f-e58927a65619
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

much appreciated Micropod, ill give the text form fields option a try.

..and apologies about the cross posting.

ok, I've tried adding text form fields, but am having a problem populating these fields.

Please see attached. The values in red, yellow and green have been populated by double-clicking the text form field and populating the values in the pop-up dialogue box. But I don't want the users to do this. I simply want them to be able to click in the field and type the value.

For Blue, I placed the cursor in the leftmost position in the field and typed, but this puts the value outside the field. When I simply click on the field and type (purple) the text form fields disappears and simply enters the number to the cell.

I have design mode switched off. What am I doing wrong? Is there some kind of other setting or default I may have switched on/off which is preventing me from simply clicking in the field and typing?

any help much appreciated.

Attached Files

Customer types_b.docx (14.3 KB, 8 views)

Your problems are because you haven't applied forms protection to the document. My previous post said you would need to do this. See under Developer|Restrict Editing|Editing Restrictions>Filling in Forms.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Paul - you're a star