display message if try to delete any cell in column E which has "OK"

[marreco]

Hi.

I need to trigger a message tab ("Action"), if the user delete any data in the cells of column A to column J if column E contains the criterion "OK"

[marreco]

thanks for help but I can not lock the guide.

all cells should be free, but I need to warn the user before deleting it, qualque row cell in column E is where as "OK"

[marreco]

Hi.
Thank you!!
Column_A Column_B Column_C Column_D Column_E Column_F Column_G ColumnH Column_I Column_J
Krono -------5.000-----5.000 y---- --OK-------12/8/2013 dataF dataG dataH dataI dataF

works, but I need the message to appear if any cell in row 1 is deleted.

the criterion for the message to be triggered, it is column E.

then E3 = "OK" any (A3, B3, C3, D3 etc) cell line 3, if deleted, will appear the message box.


case E7 = "OK" any (A7, B7, C7, D7 etc.) cell line 7, if deleted, will appear the message box.


and so on

[marreco]

Hi
could you show me an example, please?

thank you!!

[marreco]

Hi.

i think
I tried something like ...

Please Login or Register  to view this content.

but the code deletes the whole line, I need this to happen if the user wants to delete a cell or two or three, or a range of lines

[marreco]

Hi.
Considering the image.
I did not understand, the message should appear if the user delete (A2, B2, C2, D2, E2, F2, G2, H2, J2) because IN E2 is with status "OK"

In your code, msgbox is displayed if you delete any cell (A3, B3, C3, D3, E3, F3, G3, H3, J3), because AT E3 is with status "Home" Considering the image.
I did not understand, the message should appear if the user delete (A2, B2, C2, D2, E2, F2, G2, H2, J2) because IN E2 is with status "OK"

also the message should appear if the user delete (A5, B5, C5, D5, E5, F5, G5, H5, J5), because AT E5 is with status "OK"



in your code, the case appears Feedback deletes any cell (A3, B3, C3, D3, E3, F3, G3, H3, J3), because E3 is ON status to "Home"
but should not appear because E3 is supposed to "OK"

[marreco]

hi.

Any idea??

thanks

[Trebor76]

Hi marreco,

Try this adaptation of Mukeshy12390's code:

Please Login or Register  to view this content.

HTH

Robert

[marreco]

Hi Trebor76
I am very grateful for my help, but I noticed that once the Feedback appears, has moments that no aarece mais.de anyway thanks!!

[Trebor76]

Thanks for the feedback and I'm glad we got it sorted