![]() |
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 |
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