spellnumbernot workingr all excel workbook need help

[saquibansari]

hello
i have code to covert number to word but problem is its working only for current excel sheet till the time i am using after closing its doesn't work. how can i make it work for every excel worksheet and every time no need to follow same process

STEPS i m using is...
1. COPY CODE THEN IN EXCEL (ALT+F11) THEN INSERT MODULE PAST FORMULA AFTER THAT SAVE AS (macro enable worksheet.xlsm) in C Drive.

i m using excel 2007.

Thanks & Regards
Saquib Ansari
[email protected]
Mumbai -India

[simarui]

hi saquibansari,

this is a little difficult to follow what you're trying to accomplish. it sounds like you have code that is working correctly, but you want it to run on all worksheets in the workbook, is that correct? you should be able to wrap it in a for loop like this:

Please Login or Register  to view this content.

it also sounds sorta like you don't want to copy and paste it into each new workbook, is that correct? the best solution will be to add this to your personal macro workbook. doing so will make that macro available every time you open excel.

https://support.office.com/en-nz/art...0-6e4c3f5ee566

be careful here - i wrote "for each worksheet in activeworkbook..." you will need to be sure you've selected the workbook on which you want this code to run before running that macro. make sense?