Thanks Dave. I was already thinking about a helper file to open the tw
workbooks. But I'm working with an end of year deadline and have
bunch of other stuff to do. I think I'll just go with the Edit Link
like you suggested and pray I don't forget to turn it around when
distribute the executable. I'll just have to make it a rule that th
pricing file never changes it's name.

On the vlookup, it is for a pricing table and the user can enter an
whole number and it looks for a value in between and returns th
numbers I require.

It seems that the more I learn about Excel just shows me how little
really know

--
Bruce00
-----------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...fo&userid=2663
View this thread: http://www.excelforum.com/showthread.php?threadid=49082