Hiding Columns

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!
 
C

CLR

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
 
D

Don Guillett

You could put the necessary columns outside the normal viewing area and set
a scroll area
activesheet.scrollarea="a1:x21"
 
Top