Good evening Steven

When you say "a change in the sheet" do you mean when the sheet is
changed or when the user changes sheets? If the former, which I
suspect, try this, inserted in the relevant sheet's code section.

Private Sub Worksheet_Change(ByVal Target As Range)

' Your code can go in here

End Sub

Your macro would then trigger every time that particular sheet is
changed.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=380252