Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show a customised message when a trying to edit a locked cell
How do I get Excel 2007 to show a customised message when I try to edit a
locked cell? I would like it to say 'ha, ha - you can't change this cell' rarther than the boring 'The cell or chart you are trying to change is protected and therefore read only.......' I'm sure older versions of Excel let you do this. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show a customised message when a trying to edit a locked cell
I don't think older versions of excel allowed you to do this and I don't think
you can get to the internals of excel to change this message. But you could protect the worksheet and uncheck that "select locked cells" option. Then the users won't be able to easily select those cells. Emily Ladywell wrote: How do I get Excel 2007 to show a customised message when I try to edit a locked cell? I would like it to say 'ha, ha - you can't change this cell' rarther than the boring 'The cell or chart you are trying to change is protected and therefore read only.......' I'm sure older versions of Excel let you do this. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show message on locked cells | New Users to Excel | |||
Locked Cell - can still edit | Excel Worksheet Functions | |||
locked for editing message | Excel Discussion (Misc queries) | |||
edit comments in locked cells | Excel Worksheet Functions | |||
How do I add a balloon message to a locked cell | Excel Discussion (Misc queries) |