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.

1. 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.

2. Video: Clear Cell Content on Open or Exit

This Excel video tutorial tutorial will show you how to clear cell contents when opening or closing an Excel workbook. We’ll explore how to use VBA macros to streamline this process for maintaining data privacy or resetting data.

Leave a Reply