This could work, right click on the worksheets tab
select view codes
in the code window select worksheet from the drop down, in the dropdow
to the right select SelectionChange
place you macro code in the sub, when ever you change the selection o
the sheet the macro will kick in.
Use the code below as an example:
MsgBox "Macro goes here"
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "Macro goes here"
End Su
--
davesexce
-----------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...fo&userid=3170
View this thread:
http://www.excelforum.com/showthread.php?threadid=57339