ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I prevent the use of delete key in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/193112-how-can-i-prevent-use-delete-key-cell.html)

Excel doubt cleared

How can I prevent the use of delete key in a cell
 
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

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


All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com