| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabled cells
Hi all,
How can i disable users to edit certain cells on the sheet and to display a certain message whenever users fails to edit these cells ?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabled cells
Change the cell to locked & any cell you want the user to alter to unlocked
and then protect the sheet under the tool - protection menu -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Pietro" wrote: Hi all, How can i disable users to edit certain cells on the sheet and to display a certain message whenever users fails to edit these cells ?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabled cells
Pietro
Seems like this is a contradiction. You want to disable users to edit certain cells but display a message if they fail to edit these cells. See help on cell locking and unlocking and Sheet Protection. Gord Dibben MS Excel MVP On Mon, 19 Feb 2007 03:33:38 -0800, Pietro wrote: Hi all, How can i disable users to edit certain cells on the sheet and to display a certain message whenever users fails to edit these cells ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros are disabled . . . and they shouldn't be | Excel Discussion (Misc queries) | |||
| autofiler disabled | Excel Discussion (Misc queries) | |||
| Excel auto formats cells with numbers - Can it be disabled? | Setting up and Configuration of Excel | |||
| Paste disabled | Excel Discussion (Misc queries) | |||
| 'Save As' Disabled please help! | Setting up and Configuration of Excel | |||
Hybrid Mode
