software

I have a program in Excel 2000. It works well. Recently I upgraded to Excel
2003 then the combo box does not work well any more. The problem is when I
click on the down arrow to select a name in combo box, it just works for the
first time, the second time it shows the error message like this:

quot;The cell or chart you are trying to change is protected ad 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 passwordquot;.

The cellink is locked. If I unlock the celllink, it works well, but that
cell must be locked.

Please let me know as soon as possible by reply to my email:

Thank you.
Tvnguye

Hi!

gt;The cellink is locked. If I unlock the celllink, it works well, but that
gt;cell must be locked.

Well, that's how it works. If you're concerned about tampering hide the
linked cell.

Put it quot;underquot; the combo box. Out of sight, out of mind.

Biff

quot;Tvnguyequot; gt; wrote in message
...
gt;I have a program in Excel 2000. It works well. Recently I upgraded to
gt;Excel
gt; 2003 then the combo box does not work well any more. The problem is when
gt; I
gt; click on the down arrow to select a name in combo box, it just works for
gt; the
gt; first time, the second time it shows the error message like this:
gt;
gt; quot;The cell or chart you are trying to change is protected ad therefore
gt; read-only. To modify a protected cell or chart, first remove protection
gt; using the UnProtect Sheet command (Tools menu, Protection submenu). You
gt; may
gt; be prompted for a passwordquot;.
gt;
gt; The cellink is locked. If I unlock the celllink, it works well, but that
gt; cell must be locked.
gt;
gt; Please let me know as soon as possible by reply to my email:
gt;
gt;
gt; Thank you.
gt; Tvnguye