jmenche
09-29-2011, 07:44 AM
Folks,
I am trying to set up a simple TOC that sends the user to a particular cell in the next sheet (there are only two sheets). I am trying to use the Worksheet SelectionChange event so it fires right away BUT I am running into issues when I want to send the user to another sheet. I think it doesn't like the active sheet to lose focus.
The goal would be for someone to click on the cell address in column C and be magically transported to that cell in the next sheet ('Banner 1').
I attached a file but had to delete the actual data on the second sheet for file size purposes.
Any help is greatly appreciated.
:beerchug:
I am trying to set up a simple TOC that sends the user to a particular cell in the next sheet (there are only two sheets). I am trying to use the Worksheet SelectionChange event so it fires right away BUT I am running into issues when I want to send the user to another sheet. I think it doesn't like the active sheet to lose focus.
The goal would be for someone to click on the cell address in column C and be magically transported to that cell in the next sheet ('Banner 1').
I attached a file but had to delete the actual data on the second sheet for file size purposes.
Any help is greatly appreciated.
:beerchug: