If a cell containing a specific term is double clicked then

Hi Guys,

I want to be able to detect when a specific value of cell is double clicked. Instead of allow the user to edit the text in this cell I want it to automatically take them to another sheet as soon as the double click event happens

How do i go about doing this?

regards

You can use the following example (just place this code under whatever sheet you want to use as your triggering sheet) to cause a double click event on a specific cell (A1 in this case) to cancel the entry and move to a new sheet;

Please Login or Register  to view this content.