Like the title says, I am working on a project in Excel that requires that
the data entered in a range be cleared. I tried the following code in the
deactivate event of the worksheet:

Private Sub Worksheet_Deactivate()
Range("b18:l40").ClearContents
End Sub

This works fine if I switching worksheets but I would like the clear to
occur when closing Excel. I did not see a "OnClose" type event where I could
put the code for clearing the selection.

Thanks in advance.

Should be like this:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call...your macro name
End Sub

I use this all the time. Something very simple; effective too!
Place the code in 'ThisWorkbook'.

Regards,
Ryan---

--
RyGuy


"E" wrote:

> Thanks that worked great. A little different than Access.
>
> E
>
> "Rick Rothstein" wrote:
>
> > Use the ThisWorkbook code window instead of the Worksheet's code window
> > (either pick it from the Project Window or, from any worksheet, right click
> > the icon immediately to the left of the File menu item and click View Code
> > from the popup menu that appears). Select Workbook from the left hand drop
> > down and then select the BeforeClose event from the right hand drop down and
> > put your code there.
> >
> > --
> > Rick (MVP - Excel)
> >
> >
> > "E" <(E-Mail Removed)> wrote in message
> > news:2E7B80E1-183C-428C-BC9A-(E-Mail Removed)...
> > > Like the title says, I am working on a project in Excel that requires that
> > > the data entered in a range be cleared. I tried the following code in the
> > > deactivate event of the worksheet:
> > >
> > > Private Sub Worksheet_Deactivate()
> > > Range("b18:l40").ClearContents
> > > End Sub
> > >
> > > This works fine if I switching worksheets but I would like the clear to
> > > occur when closing Excel. I did not see a "OnClose" type event where I
> > > could
> > > put the code for clearing the selection.
> > >
> > > Thanks in advance.
> >
> >