<div>
BTW - there is no Event Before_Close is why I elected the answer I did
</div>


BTW - there is no Event Before_Close is why I elected the answer I did

<div>
<div class="content wysiwyg-content">
Folks,<br />
I would like to know the code and what event to place it when a worksheet is closed (workbook remains open) and I go to another worksheet, coded columns and rows would be deleted.<br />
I believe I have the correct code but I do not see an worksheet close event?<br />
Range(&quot;F1&quot;).EntireColumn.D<wbr />elete<br />
Range(&quot;A21,A31&quot;).EntireRow<wbr />.Delete
</div>
</div>


Folks,
I would like to know the code and what event to place it when a worksheet is closed (workbook remains open) and I go to another worksheet, coded columns and rows would be deleted.
I believe I have the correct code but I do not see an worksheet close event?
Range("F1").EntireColumn.Delete
Range("A21,A31").EntireRow.Delete

Delete columns or rows when wroksheet close

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.