P
Pheasant Plucker®
Hi there,
I have a spreadsheet that is protected but you are able to select a drop
down list of options in a chooser and the selected choice will be entered
into the box - or at least it will on Excel 2000
When I load the same spreadsheet (the exact one) into Excel 2003 all but one
of the chooser type boxes work apart from one.
When I click in the cell, click the triangle in the chooser and pick a name
from the list I get the error;
'The cell or chart you are trying to change is protected and therefore read
only.
To modify a protected cell or chart, first remove protection using the
Unprotect Sheet command (Tools menu, Protection submenu). You may be
prompted for a password.'
Now I have other chooser lists in this same spreadsheet that work under
Excel 2003 - it is just this one that is affected.
As I said the problem one works OK under Excel 2000 on another machine.
Why is this?
Is it likely to be a setting within Excel 2003?
Unprotecting the sheet is not really an option as I only want those
pre-defined entries to be selected and don't want others playing with it.
Can some kind soul help please?
I have a spreadsheet that is protected but you are able to select a drop
down list of options in a chooser and the selected choice will be entered
into the box - or at least it will on Excel 2000
When I load the same spreadsheet (the exact one) into Excel 2003 all but one
of the chooser type boxes work apart from one.
When I click in the cell, click the triangle in the chooser and pick a name
from the list I get the error;
'The cell or chart you are trying to change is protected and therefore read
only.
To modify a protected cell or chart, first remove protection using the
Unprotect Sheet command (Tools menu, Protection submenu). You may be
prompted for a password.'
Now I have other chooser lists in this same spreadsheet that work under
Excel 2003 - it is just this one that is affected.
As I said the problem one works OK under Excel 2000 on another machine.
Why is this?
Is it likely to be a setting within Excel 2003?
Unprotecting the sheet is not really an option as I only want those
pre-defined entries to be selected and don't want others playing with it.
Can some kind soul help please?