Double Clicking to go to precendent cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my old version of excel I double clicked on a cell and it went to the cell the value had come from - how do I set this on in Office 2003
 
Tools/Options/Edit - deselect "edit directly in cell"

To have it both ways, use VBA to trap the beforedoubleclick event:
right-click the sheet tab, select view code, then enter:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
cancel=True
Selection.DirectPrecedents.Select
End Sub
 
Back
Top