sorry ;i missed one point the sub heading is

Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub
after clicking workbook goto right side click <before closse> then write
your code statements.

mine is excel 2000
Carl Bowman <CarlBowman@discussions.microsoft.com> wrote in message
news:1A4A2455-5CC8-4248-A4B2-D681C1B555AA@microsoft.com...
> I am trying to build a macro that will automatically clear the contents of
a
> certain cell just before the workbook is saved. I tried entering is as
> follows but it did not work:
> Sub Workbook_BeforeSave()
> Sheets("Instructions").Select
> Range("E5").Select
> Selection.ClearContents
> End Sub
> Thanks
>