JackkG
05-07-2015, 09:44 AM
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
-----
cross-posted here:
http://www.excelforum.com/showthread.php?t=1081408&p=4066304#post4066304
http://www.mrexcel.com/forum/excel-questions/853731-i-want-help-track-precedents-dependents.html#post4151533
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
-----
cross-posted here:
http://www.excelforum.com/showthread.php?t=1081408&p=4066304#post4066304
http://www.mrexcel.com/forum/excel-questions/853731-i-want-help-track-precedents-dependents.html#post4151533