how do i lock individual cells within a worksheet?
 

Hi Earl,

Saw your post and want to ask on how to ungroup a group ranges when it's
protected? This is what i need to do, I have a bunch of tabs for each
department in one worksheet and i don't want unathorized employees reading
specific tabs unless they have the password for it. Once they are in that
tab, they need to ungroup the ranges and after that, they can only edit
specifc ranges and not all.
But unfortunately, i can only protect certain ranges if the worksheet is
protected without using the grouping and ungrouping the data, which means i
have to show confidential informations to other owner of tabs and it's just
that they can only read but not edit.
Is there a way that i can protect the sheet from unathorized reader? Or Is
there a way to unprotect the sheet so that users can use the group and group
function and yet can only edit specific ranges?
Thanks,
MJ

how do i lock individual cells within a worksheet?
 

"MJ" wrote:

I would like to be able to do the same in excel. I came to the conclusion I
need a true accounting database software package with a good report writer a
average finance/accounting professional user can use. That is the correct way
to manage security I real database. Excel is a poor Mans Database.


Hi Earl,

Saw your post and want to ask on how to ungroup a group ranges when it's
protected? This is what i need to do, I have a bunch of tabs for each
department in one worksheet and i don't want unathorized employees reading
specific tabs unless they have the password for it. Once they are in that
tab, they need to ungroup the ranges and after that, they can only edit
specifc ranges and not all.
But unfortunately, i can only protect certain ranges if the worksheet is
protected without using the grouping and ungrouping the data, which means i
have to show confidential informations to other owner of tabs and it's just
that they can only read but not edit.
Is there a way that i can protect the sheet from unathorized reader? Or Is
there a way to unprotect the sheet so that users can use the group and group
function and yet can only edit specific ranges?
Thanks,
MJ