Vba Worksheet Activate Event. Events on sheets are enabled by default. When you switch between two windows showing the.
When you switch between two windows showing the. Private sub worksheet activate me range a1 a10 sort key1 range a1 order1 xlascending end sub support and feedback. How to activate a sheet using vba let s say you are working with multiple worksheets and for you it s hard to navigate to a sheet using tab.
When you switch between two windows showing the same workbook the windowactivate event occurs but the activate event for the workbook doesn t occur.
This example sorts the range a1 a10 when the worksheet is activated. And to write a vba code for this you need to use worksheet activate method. When you insert a new worksheet it s an event. Workbook activate event excel 05 25 2019.