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

GRIFFO,
Did you read the Help on Locked, Hidden, Protection and how they interact ?

NickHK

"GRIFFO" wrote in message
...
I have realised it has something to do with the protection of the

worksheet.
The entry is not deleted and the cursor placed at the end of the entry

when
the worksheet is not protected.

The only option I have allowed users to do is "Select unlocked cells".
Should I set permissions to perform some other action such as Format

Cells,
Edit Objects or Edit Scenarios? I am not sure what these do but will trawl
the help system for solutions.

Any guidance is welcomed.

--
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