Hiding Columns

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

How can I hide a column from users and not have them
unhide it. I cannot protect the document/worksheet as I
need people to add data into it!
 
Right-click > Format cells > Protection and un-check the locked
box........this will allow changes to the highlighted cell(s) while the rest
of the sheet is protected. Do this to all the cells you want to allow
dataentry in......then protect the sheet

Vaya con Dios,
Chuck, CABGx3
 
You could put the necessary columns outside the normal viewing area and set
a scroll area
activesheet.scrollarea="a1:x21"
 
Best way to go around it is to put your column in other
worksheet and then hide the worksheet.. you can have a vba
code written with very hidden option in which no one will
allowed to unhide your worksheet and still you can use
your column.
I do this lots of time.
nisht
www.pexcel.com
 
You can hide the column and protect the worksheet as long as you leave
the cells you want users to enter data into unlocked. They can enter
data and save it but can't unhide the column.
 
Back
Top