Need event macro to tab past a (calculated) cell

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

I have an Excel 2003 List (aka Table in Excel 2007). There are some
protected (calculated) columns that I don't want users to enter data into.
But I can't protect the sheet, because that prevents users from entering a
new record at the bottom of the List.

Does anyone have a suggestion on how to deal with this? I'm thinking of
using an event macro invoked when user tabs out of say column C, which makes
the selection skip the cell in column D and go directly to the cell in
column E. I guess I'd have to use Worksheet.SelectionChange. But I don't
know how to do this..

Any help much appreciated!
 
Jeremy
I don't know much about what you want to do, but the following event
macro will select the cell in Column E whenever a cell in Column D is
selected. Does this help? HTH Otto
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 4 Then
Application.EnableEvents = False
Target.Offset(, 1).Select
Application.EnableEvents = True
End If
End Sub
 
Jeremy
    I don't know much about what you want to do, but the following event
macro will select the cell in Column E whenever a cell in Column D is
selected.  Does this help?  HTH  Otto
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Column = 4 Then
        Application.EnableEvents = False
            Target.Offset(, 1).Select
        Application.EnableEvents = True
    End If
End Sub








– Vis sitert tekst –
Click to expand...

hi jeremy

goto

http://www.erlandsendata.no/english/index.php?d=envbaeventsworksheet

hope that can help you

Regards Yngve
 
Many thanks... this is exactly what I needed. What is the purpose of the
first statement "If Target.Count >1 Then Exit Sub"? Does it just make the
routine stop each time a cell change happens?

Jeremy
==================================================
 
No. That simply says to do nothing if a multiple cell selection is made.
HTH Otto
 
Back
Top