How to hide worksheet columns & prevent unhiding for certain users...

W

Wei Wu

I have a worksheet with hourly rate column and hours
columns. Because of the confidentiality of the hourly rate
so I would like to hide the rate column but still able to
allow my team to enter hours. Sounds like I really want to
prevent unauthorized persons to un-hike the rate column but
still allow them to update hours columns.

Is it somethig do-able in excel?

Thanks in advance!

Wei Wu.

p.s. unfortunately I cannot redesign the workbook to
separate sensitive information in the separate workshet.
 
F

Frank Kabel

Hi
- select the cells for which you want allow entries
- goto 'Format - cells - Protection' and uncheck 'Locked'
- hide the columns/rows
- protect your sheet 'Tools - Proitection'

Note: This kind of protection is quite weak.
 
G

Guest

hi,
hidden columns are not very secure. if the rate is
confidential the i would not put these rates in the file
that you team will be looking at.
Instead i would put the rates in a file on MY pc that i
know is secure. then in the file that my team would be
entering hours, i would put a formula like this

=SUM(J3*'h:\codestuff\[connectpaths.xls]Sheet1'!$A$2)

cell j3 would be the hours
the rest would be the file path to the rates file,sheet
and cell.(the above formula i just tested with one of my
files)
this formuala would work wheather your rate file was open
or not. (in the above test, the file was closed and still
brought the correct data over)
this way your wage rates don't appear in your file and no
hidden columns.
 
Top