In the new version of Visual Studio 2005
There are tools for developing office applications.
You can write code that will target the on change event of a name
range.

There is only a beta version available of VSTO
And you have to write it in VB.net or C#.net.

If you want to know more about this option let me kno

--
Kaa
-----------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...nfo&userid=751
View this thread: http://www.excelforum.com/showthread.php?threadid=39119