Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for an employee benefits tracking worksheet | Setting up and Configuration of Excel | |||
Tracking worksheet | Excel Discussion (Misc queries) | |||
tracking changes on a protected worksheet | Excel Discussion (Misc queries) | |||
worksheet change tracking... | Excel Programming | |||
tracking user activity on worksheet | Excel Programming |