Preventing Viewing of certain columns by recipient

[Guest]

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.

 

[JE McGimpsey]

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.