VBA coding only working in the first sheet. It is not working in all the sheets

Dear Sirs,

I am just started macror/vba coding.

I have created a coding for displaying number in Indian currency in indian format(comma separator) in excel 2007. Though it is working in the first sheet It is not working in all the sheets. Please guide me on this.

I would like to learn how to protect the coding. If am sending this file to others other users should not view the coding.

code i have used as follows

Please Login or Register  to view this content.

Thanks & Regards
N.Srinivasan

That macro would have to be inserted specifically into the sheet module of each sheet where you want it to work. If you have 3 sheets, then you will right-click on each sheet tab, VIEW CODE, and paste in the code. So that's 3 modules, 3 copies of that same macro.


Here's a version you can put in the ThisWorkbook module instead, this one macro would then watch ALL sheets and act accordingly on all sheets:

Please Login or Register  to view this content.

Put the code given in post #2 in the ThisWorkbook module.

http://screencast.com/t/YliZx6oqUOEj

I don't see an attachment. Try again, and make sure the macro I gave you is already installed so I can see what you tried. Thanks.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

I opened your file and started clicking on cells in various sheets, every cell I clicked on reformatted itself.

Thank you very much,
How to make this happen after pressing enter key or tab
ie while entering the number it should get formatted by itself

Change this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

The code want to change the values and therefor you get an error.

if you put an ' before above line in the code, you will be able to delete, insert, erase, rows.

After you've done that you have to delete the ' for the code.

With other words, you have to rewrite the code so you will be able to do delete, insert and erase.

I can't help you with that, maybe someone else can make it for you.

Add this line at the top:

Please Login or Register  to view this content.