Hi everybody
My worksheet contains worksheet_change event based on range name "ID". What
i want is when i save or close the workbook i want ID = "". I have written
the following code

Private Sub Worksheet_save()
Range("id") = ""
ActiveWorkbook.Save
End Sub

It works only when i run it from VB window.
Any suggestions.
Thanks in advance
With regards
Sreedhar