View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnDiese JohnDiese is offline
external usenet poster
 
Posts: 3
Default How to lhide - lock columns (with a passord) BUT without preventin

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