How to set macro for one specific sheets?

[alz]

How to set macro for one specific sheets?
Example. Sheets name : A001, A002,A003
I want to run my vba code to run when active sheet is A001.
Please advise .Thanks

 

[Saurabhj]

Hi Alz,
1. Goto VBA editor and double click on sheet A001 in project explorer.
2. In Code window, select worksheet in left drop down and Activate in right drop down.
3. Writer your macro in created event handler.

(See attached image)

 

[Saurabhj]

Thanks for the feedback alz.

 

[eduzs]

If you want a code to run only if active worksheet name is "A001" then try:
If you want to run when A001 is activated then use the code above.

Sub Test()
If ActiveSheet.name<>"A001" Then Exit Sub
Msgbox "Hello world! The active worksheet is named A001!"
End sub

 

[alz]

Thanks for the feedback alz.

Thanks Saurabhj

 

[alz]

If you want a code to run only if active worksheet name is "A001" then try:
If you want to run when A001 is activated then use the code above.

Sub Test()
If ActiveSheet.name<>"A001" Then Exit Sub
Msgbox "Hello world! The active worksheet is named A001!"
End sub

Thanks