View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emily Ladywell Emily Ladywell is offline
external usenet poster
 
Posts: 1
Default 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!