Making this macro run automatically when the worksheet tab is activated

Hello

I currently have this macro running on a page when I click a button but would like it to do this automatically when i switch to the tab from another one. How do I change the code to make this happen?

Please Login or Register  to view this content.

Thanks

Use the Workbook_SheetActivate event

Please Login or Register  to view this content.

Would that go before or after the code I wrote? Or incorporated into it? And is there a way to do it without the message box?
Thanks

The message box was just there to show you it works. The Workbook_SheetActivate event is different than a subroutine, which is what you wrote. Your code, minus the sub and end sub would go inside it.