Worksheet change event

[Piyush_Sanghavi]

Hi,

I have to write a worksheet change code in a specific worksheet in a workbook. That means, I have a workbook named ABC having 3 sheets as a, b, c . so i want to write change event code for sheet b only. It should be run in sheet b only not for all sheets present in workbook.

Thanks & Regards,
Piyush

 

[Deepak]

Then what's the issue.
Type the code in Sheet b only.

 

[Piyush_Sanghavi]

Thanks for you reply, Yes, I written code in the sheet b only however the code also checks for other sheet (a & c) as well because of which I am getting error against that sheet.

 

[Deepak]

Or you might interested a video tutorial for the same.

 

[Deepak]

If it doesn't solve the issue then upload the sample file & we will address it.