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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trace Dependents - not working 2
Double Click to go to source 1
AutoFill double click does not work in Excel 2007 3
Trace Auditing Pointing to Dependent Cells in a Different Worksheet 1
Double Clicking in Cell-- unwanted move 5
Why wont the Excel file load when I double click on it? 2
Double Click to go to precedent 2
Format Painter overwrites text 4

Back
Top