Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How does one prevent the recipient of an excel spreadsheet from unhiding
columns or rows. For example, I have hidden columns of "cost price" on a spreadsheet and do not want the recipient to be able to view the "cost price" info. |
#2
![]() |
|||
|
|||
![]()
Well, you could password protect the sheet (Tools/Protection/Protect
Sheet...), but anyone with enough gumption to find these newsgroups could bypass that protection in a heartbeat: http://www.mcgimpsey.com/excel/removepwords.html You should assume that if someone can open your workbook that they have full access to everything in it. And even password protecting your workbook doesn't provide *all* that much protection. In article , "markd" wrote: How does one prevent the recipient of an excel spreadsheet from unhiding columns or rows. For example, I have hidden columns of "cost price" on a spreadsheet and do not want the recipient to be able to view the "cost price" info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Tallying columns based on values of 2 different columns | Excel Worksheet Functions | |||
can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |