I am in XP-SP2 with XL 2003.

I would like to know when a change is made to any cell on the sheet,
but not every time I open the sheet to consult. It appears that a
recalc is made upon opening.

Anything I can do about that?

Many TIA--Terry
Terry--WB4FXD
Edenton, NC

One way:

Put this in your worksheet code module (right-click the worksheet tab
and choose View Code:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Range("A1")
Application.EnableEvents = False
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
Application.EnableEvents = True
End With
End Sub



In article <(E-Mail Removed)>,
(E-Mail Removed) (Terry) wrote:

> I am in XP-SP2 with XL 2003.
>
> I would like to know when a change is made to any cell on the sheet,
> but not every time I open the sheet to consult. It appears that a
> recalc is made upon opening.
>
> Anything I can do about that?
>
> Many TIA--Terry
> Terry--WB4FXD
> Edenton, NC

On Mon, 19 Feb 2007 14:26:07 -0700, JE McGimpsey
<(E-Mail Removed)> wrote:

=>One way:
=>
=>Put this in your worksheet code module (right-click the worksheet
tab
=>and choose View Code:
=>
=> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
=> With Range("A1")
=> Application.EnableEvents = False
=> .NumberFormat = "dd mmm yyyy hh:mm:ss"
=> .Value = Now
=> Application.EnableEvents = True
=> End With
=> End Sub

It appears to be working! Thanks so much. You guys are great!!

Cheers--T

=>
=>
=>
=>In article <(E-Mail Removed)>,
=> (E-Mail Removed) (Terry) wrote:
=>
=>> I am in XP-SP2 with XL 2003.
=>>
=>> I would like to know when a change is made to any cell on the
sheet,
=>> but not every time I open the sheet to consult. It appears that a
=>> recalc is made upon opening.
=>>
=>> Anything I can do about that?
=>>
=>> Many TIA--Terry
=>> Terry--WB4FXD
=>> Edenton, NC

Terry--WB4FXD
Edenton, NC