how can I password hidden columns
 

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

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.



David Allen wrote:

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

--

Dave Peterson