Thread: Creating a Form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Creating a Form

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.