Clear Cell on Open or Exit of the Workbook

This post will guide you how to clear the contents of a cell or range of cells on open of the workbook in excel. How do I clear cells before workbook close or open with VBA code in excel. How to clear cells on workbook open in excel.

Clear Cell Content on Open or Exit


Assuming that you have workbook and you want to clear the contents of the specified cells or range (B1:B5) whenever you open the workbook file or whenever you close the workbook file. How to achieve it? you can do the following steps to achieve the result.

Note: Before you run the VBA macro code, you need to save as the current workbook, and set the save as type as: excel Macro-Enabled Workbook.

#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Get the position of the nth using excel vba1

#2 then the “Visual Basic Editor” window will appear.

#3 click “Insert” ->”Module” to create a new module

convert column number to letter3

#4 paste the below VBA code into the code window. Then clicking “Save” button.

clear cell on workbook open:

Private Sub Workbook_Open()

    Application.EnableEvents = False

        Worksheets("Book1").Range("B1:B5").Clear

    Application.EnableEvents = True

End Sub

clear cell on workbook close:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Worksheets("Book1").Range("B1:B5").Clear

End Sub

So far, when you close or open this workbook, and it will clear the contents of the specified cells or range of cells automatically.

 

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar