Hi Jigio,

Have you tried the Euro Currency Tools Add-in? Although this isn't all
that good, really!

Your best bet is to insert another column with formulas to convert that
are driven by a cell containing the exchange rate that can be changed
every day, if necessary. You can then format the cells as you please.
This also removes the need to run a macro using a toolbar button.

Good luck,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=401869