You'd need to put your code to clear in a Workbook_BeforeClose event.

HTH,
Barb Reinhardt
"Joost" wrote:

Hello,

Is it possible to clear cells when a workbook is closed with vba
automatically.
I can't figur it out who can help me

Thanks