I've found some code (follow link below) and it works great. One downside is
that it doesn't show the sheet name of the dependent or precedent ranges.
Does anyone know how to show this?

http://groups.google.com/group/micro...bef2ab23cac320