using worksheet.change function
 

Hi everyone,
I have some names in column a. now i want to
implement something so that when anyone tries to change column a it
should display a msg box. i need to use the worksheet.change function.
if any other solution is there it wil be welcome.


thanks for all the help

using worksheet.change function
 

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
MsgBox "May I help you? "
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"connexion" wrote in message
...
Hi everyone,
I have some names in column a. now i want to
implement something so that when anyone tries to change column a it
should display a msg box. i need to use the worksheet.change function.
if any other solution is there it wil be welcome.


thanks for all the help