Action when cell is clicked

[LSM1604]

Hi,

I have a locked worksheet where there is data in the range B6:FT43, however only some of the cells contain data (which cells contain the data and the number of cells containing data depends on what is entered on the form). The cells can be selected but cannot be changed as they are locked.

What I would like to do is, if there is data in a cell and it is clicked on, I would like a form to show asking if they would like to delete the entry. If no is clicked then nothing happens, but if yes is clicked then the data within the cell is removed (cell to remain). If there is no data in the cell when it is clicked, nothing should happen.

I was wondering if something like this can be done, and if so, how?

Hope it makes sense?

Thanks,
LSM1604

[Bob Phillips]

Please Login or Register  to view this content.

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.

[Domski]

Try this:

Please Login or Register  to view this content.

Right click on the sheet tab, select view code and paste the above onto the code sheet that appears.

Dom

[LSM1604]

Thank you very much for your help. I used this section of code:

Please Login or Register  to view this content.

Thanks

LSM1604