Alert before deleting contents of a cell

Hi, I would like to add an alert to an Excel 2013 spreadsheet that is used by a number of members staff. The purpose of the alert is to prevent accidental deletion of cell contents. It could say something like "Are you sure you want to delete the contents of this cell?" It would then give the choice of answering Yes or No. Is there an option I can choose somewhere? Many thanks Matthew

I wish I knew the answer for you, but I do know it has to be done with VBA code. If you upload a sample sheet and make sure you list the cells that you want that option on, someone on here could easily tell you how to make it work.

Hi DutyManager

Try the code below & see if it does what you need
Right click a sheet tab, click view code & paste the code below in the window.

Attached is a demo workbook for you to test
I can't attach files on this forum, a dropbox link does it nicely

Cheers

Please Login or Register  to view this content.

https://www.dropbox.com/s/hh31iotqb0...firm.xlsb?dl=0

Hi.

I have added your code on the attached worksheet and tried. But it doesn't works. Pls let me know whats the mistake i have done!

Thanks.
Thilak N

Hi Perpectuals

1) It does work as it's supposed to. I admit I didn't explain in my post that as it is it protects cell G4 only.
2) Don't hijack other peoples threads. Start your own

Cheers