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.
|