http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/

 

Na, ezek azok amitől leteszem a hajamat:

 

"Do you know that you can use a UDF as source for hyperlink.

Just like we can write =HYPERLINK(“http://chandoo.org/”,”Click here”)
we can also write =HYPERLINK(myFunction(),”Click here”)

And Excel would run your function when user clicks on the link.
But, there is more to it.
Excel would also run the function, when you place your mouse on the link. No need to click!"

 

"But, seasoned VBA programmers would know that Functions are not allowed to change values in other cells or format them. Well, that restriction does not apply if you use a function from Hyperlink!!!"

 

Most komolyan, ezeket a trükköket ki találja meg?

Ilyenkor jövök rá, hogy van okom szerénynek lenni excel témakörben...