Conversion Of Numbers To Words In Indian St.

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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.