B
bjb
One of our operatives would like to add comments to onlocked cells within a
protected spreadsheet is this possible?
protected spreadsheet is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Yes if you have Excel 2002 or newer.
Tools>Protection>Protect Worksheet>Allow users to:
Checkmark "edit objects"
That will allow users to enter Comments in any cell, not just unlocked
cells, so best to disallow "select locked cells" also.
Gord Dibben MS Excel MVP
Tools>Protection>Protect Worksheet>Allow users to:
Checkmark "edit objects"
That will allow users to enter Comments in any cell, not just unlocked
cells, so best to disallow "select locked cells" also.
Gord Dibben MS Excel MVP
D
Dave Peterson
xl2k (and before) has 3 options on that protection dialog.
One of them does the same as as the "edit objects"--maybe it's even named the
same????
One of them does the same as as the "edit objects"--maybe it's even named the
same????
D
Dave Peterson
Ps. But xl2k and before doesn't have that option (in the user interface) to
prevent the user from selecting locked cells.
prevent the user from selecting locked cells.
G
Gord Dibben
Thanks Dave.
Can't remember that far back.
Gord
Can't remember that far back.
Gord