Hello,

Please can somebody tell me if and how can I "hide and lock" a column (or
row) with a password so that other people cannot see it, BUT without
preventing others to use feature like hide / display or group / ungroup on
other columns (or rows).

Example :
I want to "hide and lock" column D with a paswword (internal use only)
My spreadsheet has many grouped columns that other people shoud have access
to.

If I use Tool / protect ....I have seen that whenever I try to expande
grouped columns, the password is required whatever the culumns.

Many thanks for your help.
Kind regards

John

If you have information that others must not see, don't put it in excel. If you
have to put it in excel, don't share the workbook with others who must not see
it.

Excel's security is not made to prevent this kind of access. It's easily
broken.

JohnDiese wrote:

Hello,

Please can somebody tell me if and how can I "hide and lock" a column (or
row) with a password so that other people cannot see it, BUT without
preventing others to use feature like hide / display or group / ungroup on
other columns (or rows).

Example :
I want to "hide and lock" column D with a paswword (internal use only)
My spreadsheet has many grouped columns that other people shoud have access
to.

If I use Tool / protect ....I have seen that whenever I try to expande
grouped columns, the password is required whatever the culumns.

Many thanks for your help.
Kind regards

John

--

Dave Peterson