Hiding Columns

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

 

[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

 

[Don Guillett]

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