Hi

Hoping someone can help me.

I have a workbook, which contains 6 spreadsheets.

One of the spreadsheets is a data capture page called 'MUST BE COMPLETED FIRST!!'. This page then populates a spreadsheet entitled 'JUNE 2013'

What I would like to know is what is the best way for this workbook to autoclear certain cells within the data capture page only when the user opens the workbook.

I don't want it to clear any of the cells from the other worksheets. If anyone can help it would be greatly appreciated

Cheers