cells selection vba

[rakesh seebaruth]

hi Guys


Please find my drop box link

https://www.dropbox.com/s/t87ax5n6l6exa8o/testing2018.xlsm?dl=0

When sanction letter is selected, sheet sanction letter is opened and cell A2 is activated.Same applies for other menus

Today's date is inserted in A2,SL inserted in B2 ,002 is inserted in C2, 12 is inserted F2 and 2018 is inserted in G2. How to prevent this from happening . Each time i select sanction letter or other menus the above occurs.

thanks/regards

rakesh

 

[Fluff]

Try changing the selection event to

   If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub
   If Target.CountLarge > 1 Or Target.row < 4 Then Exit Sub

 

[rakesh seebaruth]

thanks
happy new year 2019

 

[Fluff]

You're welcome