Thread: Auto run macro
View Single Post
  #1   Report Post  
Bakar Bakar is offline
Junior Member
 
Posts: 22
Send a message via Skype™ to Bakar
Smile Auto run macro

Hi Masters
I Have a macros telling if cell B2 is not blank
clear contents in cell B3
Sub remvpw()
If Range("b2") = "1234" Then
Range("b3").Select
Selection.ClearContents
End If
End Sub
But i can run the macro only by view macros
I want to auto run whenever i insert anything in the cell B2


Plz help
Thnxs

Bakar