1 of 1 people found this helpful
I think your best solution may be to use Menu option to run your actions, then the user can go to the desired/correct sheet.
Thanks for the help. I tried messing with menus but I like the idea of selecting instead.
I found that it was the order in which I created my actions, as well as the Single Select Only on one of the actions, and deselected on the other. That ended up fixing my problem such that it always goes to the correct place depending whether I select the cell or the entire row.