I have a workbook that uses 4 different input sheets as well as another 9 sheets that uses macros dependent upon the first 4 sheets. Sometimes changes will occur to the inputs and the one of the applicable macros may not be run. I'd like to create a macro that updates a table like this:
| Marco | Status |
|---|---|
| Marco 1 | Current |
| Macro 2 | Current |
| Macro 3 | Current |
| Macro 4 | Need to run |
| Macro 5 | Need to run |
The values for for the Status column would change to "Need to run" when changes are made to the inputs that effect that macro. Running the macros for that step would change the status back to "Current." Is there a straightforward way to connect everything using VBA similar to the trace dependents function? I'm not really sure where to start other than the incredibly tedious task of tracking each individual cell or being too conservative and tracking entire worksheets.
Subreddit
Post Details
- Posted
- 9 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...