How do I execute a macro upon changing to a specific sheet?

[rkjudy]

I have a large workbook and I would like Excel to run a particular macro every time I go to a particular sheet. Does anyone know how? Thanks in advance.

[sanram]

Use this :

Please Login or Register  to view this content.

[rkjudy]

I did this. It doesn't work. Is there something wrong?

Please Login or Register  to view this content.

[sanram]

I did this. It doesn't work. Is there something wrong?

Please Login or Register  to view this content.

Remove brackets. It will be

Please Login or Register  to view this content.

[rkjudy]

Still no luck. I put this code in the named sheet found in the 'Microsoft Excel Objects' folder on the VBA screen. Is this the right place to put the code? Sorry, I'm learning. Thanks again.

[sanram]

Still no luck. I put this code in the named sheet found in the 'Microsoft Excel Objects' folder on the VBA screen. Is this the right place to put the code? Sorry, I'm learning. Thanks again.

No. Place that code on ThisWorkbook. Press Alt+F11, then you will see ThisWorkbook at the left panel. Double click on ThisWorkbook and place the code.