Thread: MS Excel

Not exactly, but what you can do is hide the rows or columns that you want to be hidden and then turn Worksheet protections on. Set a password and untick the option to allow all users to select locked cells.

This will stop them from being able to see or unhide the hidden cells.

If this is important data, don't rely on any of the password protection in MS Office. It takes seconds to get round if someone can use Google and is so inclined.

You can hide the sheet (Format>Sheet>Hide) and then password protect the workbook (Tools>Protection>Protect Workbook). The unhide option is not available once the workbook is protected. As stated above though people can apparently break the password protection easily, but in answer to your question....yes you can

pdf it...

or seperate the sheets onto seperate files and only send what you have to...

Check this recent thread on the very same topic

http://www.aulro.com/afvb/showthread...=excel+protect

Originally Posted by EchiDna

pdf it...

most versions of pdf show you everything if you look at the source file with an editor, hidden cells and all :P

Originally Posted by incisor

most versions of pdf show you everything if you look at the source file with an editor, hidden cells and all :P

So just hide what you want hidden, text copy what is visible to another spreadsheet and PDF that.

Mark

Originally Posted by Bytemrk

So just hide what you want hidden, text copy what is visible to another spreadsheet and PDF that.

Mark

or print it and scan it


geez Joel, at least tell us what you are aiming to do by protecting/hinding stuff on your excel sheet?