Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel macros truncating tabs for hidden columns. | Excel Discussion (Misc queries) | |||
How do I lock hidden columns? | Excel Worksheet Functions | |||
How do I prevent hidden columns from being revealed by another use | Excel Discussion (Misc queries) | |||
How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) | |||
a way sum only columns not hidden? | Excel Worksheet Functions |