Set cell to default value when closing workbook?

[msquared99]

Is there a way to set a cell value to a default value when a workbook is closed without VBA?

I have a dropdown list in cell A14 that has a list of names. When a user closes the workbook I would like for that cell to say, "Select your name." when the next user opens the workbook.

Is this possible or will I need to use VBA?

Thanks!

 

[Luke M]

You'll need to use VBA.

 

[Chihiro]

If there are other values that need to be saved. No. You'd need VBA.

Otherwise, just use template.