Paul Sheppard Wrote:
Hi torpido

have a look at these

http://www.xldynamic.com/source/xld.xlFAQ0004.html

http://support.microsoft.com/defaul...B;EN-US;Q213360

hi
sorry to bug u again ;)
the MS Script(2nd link) disables after re-launchign the sheet.
i mean 1st time when i add the modul it works perfictly and i did
replace the cent and dollar with my own currency(thanks for ur tip) but
when i close the sheet and re open it i get the error sign on the cell
where ive seted the =spellnumber code, it gives me the #Name error on
the cell, just like when u put a wrong function.
then i must delete the modul and save the sheet without it and re open
then re-enter the modul.
am i doing something wrong, and other link(Morefunc) works too but it
doesnt adds currecy in it.
EDIT:
I managed to work the MoreFunc with my own currency, but i couldnt set
the "after point" like Cents.
but my concern is that am trying to do this thing on my office pc and
my account is limited, i think i wont be able to install the MoreFunc
on it so i need the MS script to work. if somebody can tell me why it
screws up on every re-luanch ill be greatfull.


--
torpido
------------------------------------------------------------------------
torpido's Profile: http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=397468