Cell Protection

  • Thread starter Thread starter maacmaac
  • Start date Start date
M

maacmaac

I know how to protect individual cells in a worksheet?

Thank you in advance for your comments
 
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.
 
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
 
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!)

Peo said:
Are we off today or do we have the flu?
Click to expand...
 
The Cubs are my avocation--my calling.

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



Peo said:
I see, giant corporation? Chicago Cubs or the Swedish Bakery in
Andersonville?
Click to expand...
 
Back
Top