Clear cells on closing the workbook. Excel 2016

[dougw71]

How does one clear cells of values only upon closing the workbook; such that, the next person to open the program cannot see the value posted by the last user? I am able to write a Macro that will clear the cells when the Macro is "run"; but, how to make the Macro run upon closing or opening, that is the problem. Thanks.
Doug

 

[My Aswer Is This]

In the Vba project window double click on "ThisWorkbook"

Enter this code:

Private Sub Workbook_Open()
'Do stuff here

End Sub

 

[dougw71]

I shall work on that suggestion. Thanks, Doug