Hello. I've created forms before and protected some cells. On it's protected
state, when someone clicks on a protected cell, a warning pops up. However,
I've seen forms that have cells protected that won't even let you click on it
at all. This is what I'm trying to do. How do I do that?

Thank you.

Claudine

If you are running Excel 2002 or 2003 there is an option to not allow users to
select locked cells.

Available when you go to ToolsProtectionProtect sheet.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 13:20:00 -0800, Claudine
wrote:

Hello. I've created forms before and protected some cells. On it's protected
state, when someone clicks on a protected cell, a warning pops up. However,
I've seen forms that have cells protected that won't even let you click on it
at all. This is what I'm trying to do. How do I do that?

Thank you.

Gord,

You are awesome! Thank you very much!

Claudine

"Gord Dibben" wrote:

Claudine

If you are running Excel 2002 or 2003 there is an option to not allow users to
select locked cells.

Available when you go to ToolsProtectionProtect sheet.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 13:20:00 -0800, Claudine
wrote:

Hello. I've created forms before and protected some cells. On it's protected
state, when someone clicks on a protected cell, a warning pops up. However,
I've seen forms that have cells protected that won't even let you click on it
at all. This is what I'm trying to do. How do I do that?

Thank you.