how can I password hidden columns

D

David Allen

I have a workbook which a colleague uses to enter data. The data is then
manipulated on the same worksheet, but if these columns arehidden they can
easily be unhid. Is there a way of password protecting these consecutive
hidden columns, or an alternative please
 
D

Dave Peterson

You can hide the columns, then protect the worksheet (tools|protection|protect
sheet). But this protection is easily broken.

If you have stuff you don't want others to see, don't put in an excel workbook
that you share with others.
 
Top