Hello:
I have two sheet tabs: Step 1 and Step 2.
Step 2 has a drop down where you can either choose Yes or No in various cells. Depending on the answer, rows either hide or unhide. No problem.
But, now I am being asked to go up a notch:
in Step 1, I have cell G8 that has a drop down menu and when something is chosen, the cell in the Step 2 sheet tab automatically puts in YES (instead of having the drop down list).
The problem is, I cannot seem to trigger the event code for Step 2 to unhide the rows. It will only unhide them if I am clicking on the cell.
I know it has to do with "active sheet", but I don't know how to have an event code run when the worksheet is inactive.
The event code in Step two is Worksheet_Change.
Thank you for your time and help.
Sheri
I have two sheet tabs: Step 1 and Step 2.
Step 2 has a drop down where you can either choose Yes or No in various cells. Depending on the answer, rows either hide or unhide. No problem.
But, now I am being asked to go up a notch:
in Step 1, I have cell G8 that has a drop down menu and when something is chosen, the cell in the Step 2 sheet tab automatically puts in YES (instead of having the drop down list).
The problem is, I cannot seem to trigger the event code for Step 2 to unhide the rows. It will only unhide them if I am clicking on the cell.
I know it has to do with "active sheet", but I don't know how to have an event code run when the worksheet is inactive.
The event code in Step two is Worksheet_Change.
Thank you for your time and help.
Sheri