Protecting Cell Contents from Editing

A

Anita Taylor

Is there any way to protect the contents of cells? We have
a user who wants to "lock down" the contents of several
cells in her workbook and prevent their contents from
being edited in any way. We've tried all forms of
protection available from the Save and Tools dialog boxes.
None of them prevent us from editing the contents of
cells, and that is her ultimate goal.

Any help would be greatly appreciated!
 
F

Frank Kabel

Hi
try
- format all cells you DON'T want to lock (goto 'Format - Cells -
Protection' and uncheck 'Protected/Locked')
- goto 'Tools - Protection' and protect your worksheet
 
G

Guest

Many thanks! This worked just fine. It doesn't seem to
make much sense, but it works perfectly!

ANITA
 
G

Gord Dibben

Anita

To clarify on protection.

Note: there are 3 types of Protection

1. WorkSheet protection from Tools>Protection
2. WorkBook protection from Tools>Protection
3. File protection from File>Save As>Tools>General Options(XL2002)

And a fourth one if you count Protection on a VBA Project

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Method for protecting cells which still allows quick editing 2
Protect Number Format Only 6
Locking Excel cell formating and editing, copying and pasting cont 3
Finding and locking formula cells 2
Attempted edit of protected cell jumps user to another cell 2
Preventing cell contents from printing 5
Hiding Formulas and Being Able to Make Changes 2
Editing in Cell 5

Top