Conversion Of Numbers To Words In Indian St.

Closed
Ayan Das - 17 Nov 2011 à 04:25
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 17 Nov 2011 à 20:41
Hello,

Is there ne possibility to get the code by default as every time u open a new worksheet.B'coz wht m i gettng that able to do only at the same worksheet wherever the base code inserted into module .

Kindly suggest please.

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
17 Nov 2011 à 20:41
without the code it is difficult to give a solution
you must have written a statement somewhere
something like this
worksheets("sheet1").activate
and then the code

suppose you remove this line

open a sheet (better to use "active a sheet") and then run the macro . the macro will run on the active sheet. The macro is common to the whole workbook.

I hope I made myself clear.