Excel Worksheets

Attached is an excel worksheet.  Notice the yellow cells.  I want to protect all cells excepting those in yellow.  How do I do it.  I can protect the one yellow column of cells but not the others.
NewSalesWorksheetXtreme.xlsx
akbiroAsked:
Who is Participating?
 
balatheexpertConnect With a Mentor Commented:
Yes u r right.

and just a change, the check box i mentioned is not "Protected" but "Locked"!

and anyways, the time when you are changing the color, u can change the "Locked" property also right?

coz, thought of writing a macro for this but this is not having a certainty. If i have to set "Locked" for those which are yellow, it has to check cell by cell. it will be a bit time consuming one.

but if you can give me any range such as u will be using only these many rows and these many columns (less number of rows & columns), then i can write a macro!!! otherwise, it will be a timeconsuming one!!!

-Bala
0
 
balatheexpertCommented:
first unprotect all

set format cells->protection->locked for all the cells except for the yellow cells

now protect the worksheet. your need will be done!

thanks,
bala
0
 
akbiroAuthor Commented:
Can't find set format cells...
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
balatheexpertCommented:
select all cells

right click

select "Format cells"

select the last tab "protection"
0
 
akbiroAuthor Commented:
Let's try it a different way if you could.

1) protect the entire sheet.
2) unprotect those cells that are yellow.

How do I do that?
0
 
balatheexpertCommented:
to protect cell level, u have to set the option i had mentioned.

select entire sheet.

right click

select "Format cells"

select the last tab "protection"

check in "Protected"

now select the column u want to unprotect

check out "Protected"

now protect the entire worksheet.

this protects those cells that has "Protected" and leaves out those dont have.

0
 
akbiroAuthor Commented:
So there isn't a way to set up something in excel that when I select Protect and Unprotect, it knows to protect any cell that is not yellow.  I have to go thru this routine described above each time I want to protect it.

0
 
akbiroAuthor Commented:
I want to highlight the yellow cells and click on a protect button...that is my specific question.
0
 
akbiroAuthor Commented:
I figured it out...Just click on one of the top yellow sales.

Then Review>Changes>Protect Sheet>
Click on Select Unlocked Cells

Works like a champ!!
0
 
akbiroAuthor Commented:
THanks again!
0
 
balatheexpertCommented:
cool! it should have been by default on your worksheet. select locked cells & select unlocked cells.

great..

enjoy!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.