When in the protection tab under FormatCells checkmark the "Hidden" option so
they don't show up in the formula bar.

Then set the font to white and protect the sheet with a password.

The user enters the password and unprotects the sheet and formats the font
color to something readable.

This could all be done with a macro if desired.

NOTE: password protection on worksheets/workbooks is very easily broken.

Do not rely on this to prevent users from getting at sensitive data.

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 13:46:55 -0500, haleswd
wrote:


Thanks dominicb, but that only answers half of the question. I know
those cells could be protected, but how would a person hide them, and
have them only be able to view the data with a password.

I tried Tools Protection Allow Users to Edit Ranges...

This would work, if I was able to hide them, but I can't figure out
how. Any Idea on how to go about doing this?

Thanks for any help that you will be able to give me.