back to previous sheet
 

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.

back to previous sheet
 

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.