A
Anthony Travis
I use Office 2000 on Windows XP Professional.
I have inherited a Word document that contains form fields. The document is
protected to allow users to complete only the form fields. It also contains a
number of Excel worksheets, which contain unlocked cells for users to
complete - in the locked cells, hidden formulae then calculate totals. I
needed to change the wording (not the formulae) in the worksheet, so i
unprotected it, unlocked all the cells and chamged the relevant text.
However, when I locked the cells I needed to (leaving the user input cells
unlocked) and protected the worksheet again, I found i could still access any
cell in the worksheet from Word.
What is more, when I tried to re-protect the Word document, Word crashed
completely.
I'm fairly fluent in Word & Excel, but this is all new to me and I can't
find anything in the help sections.
Any ideas out there?
I have inherited a Word document that contains form fields. The document is
protected to allow users to complete only the form fields. It also contains a
number of Excel worksheets, which contain unlocked cells for users to
complete - in the locked cells, hidden formulae then calculate totals. I
needed to change the wording (not the formulae) in the worksheet, so i
unprotected it, unlocked all the cells and chamged the relevant text.
However, when I locked the cells I needed to (leaving the user input cells
unlocked) and protected the worksheet again, I found i could still access any
cell in the worksheet from Word.
What is more, when I tried to re-protect the Word document, Word crashed
completely.
I'm fairly fluent in Word & Excel, but this is all new to me and I can't
find anything in the help sections.
Any ideas out there?