Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting/Clearing duplicate range of cells | Excel Worksheet Functions | |||
Clearing cells in a range upon exitting Excel | Excel Programming | |||
Clearing cells in a range upon exitting Excel | Excel Programming | |||
Clearing cells in a range upon exitting Excel | Excel Programming | |||
Clearing the Contents of a range of cells | Excel Programming |