View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GRIFFO GRIFFO is offline
external usenet poster
 
Posts: 10
Default text is deleted when cell is edited

Bob / Nick,
No code behind the sheet.
Might it have something to do with the sheet properties? I have had a play
with them but no sure what I am doing.

Nick, if there is The cell has .Hidden=True and Locked=False, where can I
change this as there appears to be no VBA code in the sheet.

--
Your assistance is appreciated.
Griffo



"NickHK" wrote:

GRIFFO,
The cell has .Hidden=True and Locked=False.

Nick

"GRIFFO" wrote in message
...
Hi,

Version: MS EXcel 2002 SP2

I have a worksheet, protected, (developed by someone else) which performs
strangely when you edit cells. When you attempt to edit data previously
entered in a cell (by pressing F2 or double clicking on the cell), the
previous data entered in the cell is deleted. This happens with numbers

and
text.

Any ideas why this happens?

The worksheet and workbook are protected. The cells in question is

obviously
not locked.

--
Your assistance is appreciated.
Griffo