Protecting a Couple Cells

G

Guest

I have a workbook with maybe 10 sheets. I want to be able to select certain cells in each of the worksheets that cannot be changed. I don't seem to be able to get the right combination of Format/Sheet/Protection and Tools/Protection/Sheet-Workbook...Can anyone help??
 
F

Frank Kabel

Hi Jim
try the following:
- first select all cells for which you want allow entries
- goto 'Format - Cells - Protection' and uncheck 'Locked' for these
cells
- now goto 'Tools - Protection' and protect your worksheet

Repeat for the other worksheets

--
Regards
Frank Kabel
Frankfurt, Germany

Jim said:
I have a workbook with maybe 10 sheets. I want to be able to select
Click to expand...
certain cells in each of the worksheets that cannot be changed. I
don't seem to be able to get the right combination of
Format/Sheet/Protection and Tools/Protection/Sheet-Workbook...Can
anyone help??
 

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

Code to format cells on several worksheets 2
protecting sheets 2
David Biddulph is correct 8
Protect Only Certain Cells 2
Attempted edit of protected cell jumps user to another cell 2
protection 2
Sharing workbooks limitations - Merged Cells 12
Unprotecting worksheets 2

Top