Vba code to run when we click on a specify sheet in the workbook

[aman1234]

Hi guys

I want to run the vba code when the user click on a specific sheet in workbook. Can anyone tell me how to start doing it?

Thanks

[NickyC]

hi
right click on the tab for that sheet and select "view code"

in the drop down menu on the top left, select "worksheet"

in the drop down menu adjacent to it on the right is a list of events that can happen to that sheet which will trigger a macro

for example, you can have a macro that runs when the sheet is selected or changed.

So, to display a message "hi" every time the sheet is activated, your code is:

Please Login or Register  to view this content.

[Kyle123]

Alternatively you can set this globally in ThisWorkbook:

Please Login or Register  to view this content.