macro not running in other files

**Abdul Hai** · 05-27-2013, 07:43 AM

i have created a macro in a file for converting numbers to words like "1,000" to "One Hundred Thousand Only". When I am copying this macro in other excel file, it does not work.

**john55** · 05-27-2013, 07:47 AM

insert a module in yr (new) file, copy/paste the macro into it and run the macro, it shoulkd work!

**NeedForExcel** · 05-27-2013, 07:58 AM

As far as the code you are talking about is concerned, it is a Function Procedure isnt it?

Copy the code to a Module of your new workbook.

Thank You,

Deep

**alansidman** · 05-27-2013, 08:12 AM

If you want your code to work in all workbooks, create a Personal.xlsb file and store you macro in there. Here is a link to learn how to create a Personal.xlsb file.

http://www.rondebruin.nl/win/personal.htm