Worksheet_Selection Change to Activate another sheet in the same workbook

  • Working with data on Sheet1, I want to click on any row in Column A to activate Sheet2 or Sheet3 in the same workbook based on the value of column E. It the Value of Column E is greater than zero I want to activate Sheet2. If the value in column E is zero, then I want to activate Sheet3.

  • Re: Worksheet_Selection Change to Activate another sheet in the same workbook


    In the "Sheet1" worksheet module: