Paste this in to the worksheet code module. Every time you click a cell
on the worksheet it will call your macro
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call YOUR MACRO NAME HERE
End Sub
Regards,
Simon
--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread:
http://www.excelforum.com/showthread...hreadid=573391