Delete cell value 'c4' automatically at the time of closing the file

[mukeshbaviskar]

Dear Experts,
I want to delete the value of cell 'c4' at the time of closing the file automatically. Please suggest me a macro for it.
Thanking you in anticipation.

Mukesh

[mehmetcik]

Sub Auto_Close()
Range("C4").FormulaR1C1 = ""
End Sub

[mukeshbaviskar]

Hello mehmetcik,
Thank you but it's not working automatically. I have to manually run the macro by clicking. I want to delete the value of cells 'b4, c4' automatically at the time of closing the file. There is a little modification in cell address because in the morning I forgot to mention it. I want to delete the value of both cells 'b4, c4' automatically at the time of closing the file and make the cells blank. Next time when I open the file the cells must be blank for use.
Thanking you in anticipation.
Please see the attachment. I want to delete the names at the time of closing the file:
Baviskar 'b4' and Mukesh 'c4'

Mukesh

[mc84excel]

I love this kind of stuff

Try pasting this code into the "ThisWorkbook" module.

Sub Workbook_BeforeClose(Cancel As Boolean)
    ThisWorkbook.Worksheets("Sheet1").Range("B4:C4").ClearContents
End Sub

[mukeshbaviskar]

Hello mc84excel,
I pasted the code in the module and run it but I'm getting error name conflict with vba object. I gave the name workbook_beforeclose.
Please send me a sample attached file with code for better understanding.
Thanking you in anticipation.

Mukesh

[mc84excel]

Please send me a sample attached file with code for better understanding.

See attached.

1. Download
2. Open (Enable Macros if any macro message appears)
3. Enter something in Sheet1 cells B4 and C4
4. Save & Close the workbook
5. Open the workbook. Cells B4 & C4 should be empty.

Please mark the thread as solved if this works for you.