Clearing all cells with form results when file is opened

Is there a way to clear all form results when a file is opened?

I have 3 command buttons on a main page that spits out the results of the forms when they are completed. What I am looking to do it, have the results cleared out each time the file is opened.

Is that possible, or is there a better way to do it?

I can also add a Clear (command button) to the main page that they can hit to get started. I just cant figure out how to get it to clear the cells that display the results and provide a message of some sort in the cell like (please click the Calculate Reference Tier button to get started)

Hi
Exactly which cells do you want cleared when the workbook is opened?
Tony

Ah yes, that would be helpful.

In workbook.sheet1 I have 3 cells "location", "Type" and "Calculate"

The first 2 cells are populated from userforms by clicking on the command buttons for each and the last cell is a command button that populates based on the values provided in the prior 2 cells.

Does that help?

Hi
Are these named ranges or column headers?
Tony

The are named see attached for example.

Hi
First of all you need to ensure that the Workbook you intend to use is based on a new separate template as this macro will clear any ranges in any spreadsheet that have the same range names. Place this macro in a module and it will do what you need:

Sub Auto_Open()
'
' Macro1 Macro
'
Application.Goto Reference:="Location"
Selection.ClearContents
Application.Goto Reference:="Type"
Selection.ClearContents
Application.Goto Reference:="Calculate"
Selection.ClearContents
Range("A1").Select
End Sub

Good luck.
Tony