Thread: How can I prevent the use of delete key in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How can I prevent the use of delete key in a cell
I'd use an adjacent cell that was formatted in big bold red letters:

=if(a1<"","","<-- Please enter something here!"



Excel doubt cleared wrote:

I want to get a warning message and prevent the null value in a cell when the
contents of a cell is deleted.
Please help as I am so tired in search for this.
Roby

--

Dave Peterson
Reply With QuoteReply With Quote