Mike,

After updating D7

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$D$7" Then
ThisWorkbook.Save
End If

End Sub

in the sheet code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mikewild2000" wrote in message
...
I would like to save the workbook when the user moves out of cell D7 (or
after updating cell D7)

same as pressing ctrl+s on the keyboard.

but to do this in vba - any ideas


---
Message posted from http://www.ExcelForum.com/