M
maacmaac
I know how to protect individual cells in a worksheet?
Thank you in advance for your comments
Thank you in advance for your comments
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
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.
D
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
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
P
Peo Sjoblom
Are we off today or do we have the flu?
D
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!)
(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?
P
Peo Sjoblom
I see, giant corporation? Chicago Cubs or the Swedish Bakery in
Andersonville?
Andersonville?
D
Dave Peterson
The Cubs are my avocation--my calling.
Work is just something that fills the days (now months) between Cub games.
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?