tracking changes using worksheet calculate
 

I want to call a subroutine whenever cells in a certain range on on
particular excel worksheet calculate. Currently it looks like this:

Private Sub Worksheet_Calculate()

Call price_tracker

End Sub

However, it is calling the price_tracker subroutine if a calculat
event occurs on any worksheet in this workbook.
How can I restrict the price_tracker program to running only when cell
on a particular worksheet change?
Even better would be if I could restrict the program to running if
calculate event occurred to a specific range of cells on th
worksheet.

Go easy on me I'm pretty new to this stuff
Ti

--
Message posted from http://www.ExcelForum.com