Hi all experts,
I'm trying to track precedents and dependents of a selected cell in a sheet. For security measures, I've locked some sheets. I want a free floating bar with the options ["trace dependents", "trace precedents", "remove arrows", "go to references"].
First, on the locked sheet, I want the code to unlock the sheet and track the dependents, precedents and references of a selected cell, and then lock the model again.
If anyone can help me out with my request will be great. Two things:
1. free floating bar with the options ["trace dependents", "trace precedents", "remove arrows", "go to references"].
2. In the locked sheet, code to unlock the sheet and track the dependents, precedents and references of a selected cell, and then lock the model again.
Thanks!
Jack
Bookmarks