Hi Data Rat,

Sorry for the (very) late response, but maybe you are still looking for the
answer...
Standard all cells are set to be protected as soon as the worksheet
protection is activated.
So what you need to do is to unprotect all cells you want the user to be
able to change:

- Select one pf the input cells
- Press the [Ctrl] button and hold down.
- Select all other input cells one by one (or range by range if they are
connecting to each other) by clicking (and dragging) with the mouse.
- Release the [Ctrl] button.
- Right-click in one of the selected cells and pick 'Format Cells...' from
the pop-up menu.
- In the window 'Format Cells' select the Tab called 'Protection'
- Unmark the box in front of 'Locked'
- Click [Ok]

Now Protect the worksheet:
- Goto Tools / Protection / Protect sheet...
- Now you might want to enter a password, but it is not nescessary. If you
decide to enter a password make sure you won't forget it!!
- Click Ok...

That's it...

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl

"The Data Rat" <kia_1957@yahoo.com> schreef in bericht
news:Nte4b.34862$xf.181@lakeread06...
> Newbie to this group...
>
> We keep all of our company info on a complicated but nicely formatted
little
> excell spread sheet.  Is there anyway to prevent/protect the formatted
cells
> from someone deleting/typing in them?
>
> In other words, if cell C3 is the sum of cell C1 and C2, how can I prevent
> anyone from changing C3, but allow them to enter info in cells C1 and C2?
> Needless to say, losing the formatting defeats the whole purpose and I
have
> spent hours going through the spread sheet trying to find where the
> formatting was deleted/changed.
>
> I am using 2000 on one computer and 98 on another.
>
> Thanks!
>
>