Conversion Of Numbers To Words In Indian St.

Closed
Ayan Das - Nov 17, 2011 at 04:25 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 17, 2011 at 08:41 PM
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 June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 17, 2011 at 08:41 PM
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.
0