The bad news is that worksheet/workbook protection (under tools|protection) in
excel is not made for this kind of thing. It can be broken in a matter of
moments.
If you really have secure data that other shouldn't see, don't put it in
excel--or don't share that workbook with others.
Fern wrote:
Is it possible to restrict the view of several columns to one user? I have a
spreadsheet that the whole team enters data into. The manager wants columns
in the same spreadsheet where she can enter confidential information about
each project, so she should be the only person who can view or unhide or
ungroup those columns or something. Any suggestions?
--
Dave Peterson
|