Whoops!

Forgot to deal with the contents of the cells you want hidden.

The "hidden" property just hides the content in the formula bar.

To hide the cell contents on the sheet, before you lock them,
FormatCellsNumberCustom ;;; that's 3 semi-colons.


Gord

On Fri, 02 Mar 2007 20:16:55 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Russell

Excel's internal protection is very weak so the general rule is........if you
don't want someone to see data, don't include it in the workbook.

With that warning in mind, you can protect and hide just certain cells while the
sheet is protected.

By default, all cells are protected when sheet protection is enabled.

Hit CTRL + a(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked"

Select the cells you want protected and hidden and FormatCellsProtection

Check "locked" and "hidden".

ToolsProtectionProtect Sheet. Note the options when protecting.

Supply a password and OK.

I reiterate..........this is very weak protection. Internal protection
passwords are easily cracked.


Gord Dibben MS Excel MVP

On Fri, 2 Mar 2007 19:05:39 -0800, Russell A Fowler <Russell A
wrote:

I have a need to hide sensitive information without protecting the sheet,
hiding the column (or row), and without using white text (If a user selects
the cell, then text can be seen.) Using the hide cell protection option will
not work unless the sheet is protected and would disallow the entry of other
data.