Cell Protection

[maacmaac]

I know how to protect individual cells in a worksheet?

Thank you in advance for your comments

 

[Dave Peterson]

Each cell can be locked or unlocked. And a worksheet can be protected or
unprotected.

So if you want to allow the user to make changes to certain cells, you can
unlock those cells and then protect the sheet.

If you haven't changed the default style, every cell is locked by default. (And
I bet you haven't!)

Select your range to unlock
Format|cells|Protection tab
uncheck locked

Now protect the worksheet.
tools|Protection|protect sheet

And in versions of excel before xl2002, you may find some stuff (formatting
cells, for instance) that you want to do is unavailable on a protected
worksheet.

That said, worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.

 

[Don Guillett]

If you mean I want to know how
All cells are locked by default>select the cells you want to
unlock>format>cells>protection>uncheck locked
then protect the sheet by tools>protection>sheet

 

[Peo Sjoblom]

Are we off today or do we have the flu?

 

[Dave Peterson]

Vacation time has built up and it MUST be taken.

(I ain't donating my time to a giant corporation. Hmmmm. Well, except if it's
fun!)

Are we off today or do we have the flu?

 

[Peo Sjoblom]

I see, giant corporation? Chicago Cubs or the Swedish Bakery in
Andersonville?

 

[Dave Peterson]

The Cubs are my avocation--my calling.

Work is just something that fills the days (now months) between Cub games.

I see, giant corporation? Chicago Cubs or the Swedish Bakery in
Andersonville?