Hi all
I've been maintaining a long-standing Excel performance management template (.xltm) accessed by dozens of users and updating and storing data in multiple MS Access DBs (.accdb) for a while now, but the whole system pre-dates me by some time. As such, I'm not across all the relationships between macros and order of operations and manually inspecting these each time is time consuming.
Is there any function to trace macros as they are run in order to develop a map of relationships between macros in various circumstances? Not really fussed how this would be triggered or store data so long as I could use it to infer relationships between macros.
Thanks in advance.
I've been maintaining a long-standing Excel performance management template (.xltm) accessed by dozens of users and updating and storing data in multiple MS Access DBs (.accdb) for a while now, but the whole system pre-dates me by some time. As such, I'm not across all the relationships between macros and order of operations and manually inspecting these each time is time consuming.
Is there any function to trace macros as they are run in order to develop a map of relationships between macros in various circumstances? Not really fussed how this would be triggered or store data so long as I could use it to infer relationships between macros.
Thanks in advance.
