I finally figured it out (it wasn't obvious) - that I must enter the "Change"
macro in the sheet rather than for the workbook!!!

Thank you. It's just what I've been looking for for the last few months.

"Gord Dibben" wrote:

A particular cell or a range of cells or?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in any cell in Col A
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
With Target
If .Value < "" Then
yourmacroname
End If
End With
End If
enditall:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP

On Fri, 28 Dec 2007 12:51:03 -0800, VB_User
wrote:

I would like to execute a macro every time the "Enter" key is depressed (or
an entry is made to an Excel cell). Is there a way to do this with a special
macro (Visual Basic)? Or, is there another way?