Thanks Guys. It was the hidden option in the Format > Cell > Protection tab.

Removing the hidden option protection from the fields without formulas, then
makes the text / numerical entry editable without losing the data.

As monty burns says "Exxxxxcellllent".

--
Your assistance is appreciated.
Griffo



"NickHK" wrote:

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