Currency Format via VBA
 

Hi,

I have to solve a problem with EXCEL 2000 and/or Excel 2002. The
current Currency format is $. All money related cells are formated
using the "currency format $". What I have to do is "relatively"
simple. The user will enter a new currency symbol using a dialog once
the spreadsheet is opened. This symbol either € or £ or ¥ has to be
the new format for ALL money related cells. How can that be done?

Thanks in advance,
Thiemo Gorath