It’s been quite a while, but finally I got round to publishing a new article on my site.
It is a nice trick to make full use of the Data Validation’s Input message option, without the popup message covering your sheet.
So not like this:
But like this:
Have a look at the article on my website
I’ve been working on my RefTreeAnalyser again. What I’ve been up to this time is building tools which help with the analysis of dependencies which are mostly hidden from view:
- Charts (series formula)
- Pivot table (source data)
- Data Validation formulas
- Conditional Formatting formulas
- Form controls (linked cell, listfillrange)
- ActiveX controls (linked cell, listfillrange)
- Picture objects (linked cell)
A new dialog has been added that shows all sources of the objects in your file:
Moreover, when you analyse a particular cell for its dependencies, objects are taken into account too (well, to be perfectly honest, only if you purchase a license):
If you haven’t already done so, why don’t you head over to my website and download the tool. The demo is free and (almost!) fully functional.
Jan Karel Pieterse