is there any way/ macro that may return the user to go back to the previous
sheet?
for example if i click the "trace dependent" button and it refer to other
sheet, i click on the row, and moved to another sheet. is there any option to
back?
i know that the back of the web may be use for hyperlinks only.
--
Miri Tz.

sorry, but it is not working... maybe i did something wrong.
i added this methods and then click the shortcut... nothing happened.
by the way ctrl k bring me the window of insert hyperlink...
--
Miri Tz.


"ufo_pilot" wrote:

>
> click on a cell > Ctrl j will take you to the Precedence
> then > Ctrl k will take you back - removing all the arrows too.
>
>
> Sub GetDep()
> ' Keyboard Shortcut: Ctrl+k
> Selection.ShowDependents
> ActiveCell.NavigateArrow TowardPrecedent:=False, ArrowNumber:=1, _
> LinkNumber:=2
> ActiveSheet.ClearArrows
> End Sub
>
>
> Sub GoPrec()
> ' Keyboard Shortcut: Ctrl+j
> Selection.ShowPrecedents
> ActiveCell.NavigateArrow TowardPrecedent:=True, ArrowNumber:=1,
> LinkNumber _
> :=1
> ActiveSheet.ClearArrows
>
> "Miri" wrote:
>
> > is there any way/ macro that may return the user to go back to the previous
> > sheet?
> > for example if i click the "trace dependent" button and it refer to other
> > sheet, i click on the row, and moved to another sheet. is there any option to
> > back?
> > i know that the back of the web may be use for hyperlinks only.
> > --
> > Miri Tz.