Thread: [Solved] locking word table cells while auto-updating fields
View Single Post
 
Old 01-13-2015, 01:39 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote