Welcome to the board!
If you have a Sub titled Aut
pen like shown below, it will automatically run as soon as you open the workbook.
Following code will clear everything in the shown range of worksheet name Sheet1. You of course can put any range or sheetname you wish there.