Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Go back to the previous excel file | Excel Discussion (Misc queries) | |||
Go back to previous page | Excel Programming | |||
go back/previous cell | Excel Programming | |||
Go back to previous worksheet | New Users to Excel | |||
Roll back to previous date | Excel Worksheet Functions |