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

NickHK

"GRIFFO" <GRIFFO@discussions.microsoft.com> wrote in message
news:00BA1160-C38C-4750-90FA-4B0B78F87F48@microsoft.com...
> 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" <GRIFFO@discussions.microsoft.com> wrote in message
> > news:04037A29-D57A-418E-B3C7-9594A5C8E374@microsoft.com...
> > > 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
> > >
> >
> >
> >