Clearing template form

[apurk45]

I am using template (.xlt) to input some date (numbers, text and picture in .jpg format). After I "Save As" inputed data as a .xls file I would like to clear the template out of ALL inputed data for next set of data. I have some protected cells and sometimes I have only 1 page of data and sometimes more (2, 3 or more).
Any idea how to do it ???
Thank you

 

[jtfourh]

If you pull up a template and then save as a workbook (.xls) doesn't that leave you with the workbook with the data? Wouldn't you just pull up the template again and it would be blank since you did a save as to the workbook.

Have you considered having file as read only?

 

[apurk45]

Yes - you are correct BUT I have to do it 300+ times so I tought would be nice to automate this process. This would save me lot of clicking. In addition other people going to use this process and some of them are not very PC oriented.