i think what i am trying to do is trap an event and cause it to trigger more code...but i have no idea how...i am so lost when it comes to whether or not this is possible:
I open a new workbook.
I put this code in a module:
VB Code:
  1. If ActiveSheet.Name = ("1") Then MsgBox "yes"
I run the code on sheet 1.
if i run the code ...of course i get yes...
but how can i make it msg me everytime i select sheet 1 like automatically...???