Clearing cells in a range upon exitting Excel
 

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.

Clearing cells in a range upon exitting Excel
 

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" wrote in message
...
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.