Auto Open

[Graham]

Hi,

I have a procedure which clears down existing variable
data in a spreadsheet called "Template" as part of Auto
Open. I want this file to be clear of data whenever it is
opened by any user. However, once opened I would want
users to enter data and save the file with a different
name , e.g."NewFile". My problem is that when a user
subsequently re-opens "NewFile" to amend their data, my
auto open procedure is obviously clearing the data they
previously entered.Is there a way that I can prevent this
from happening?


Thanks
Graham

 

[Tom Ogilvy]

Sub Auto_Open()
if lcase(thisworkbook.name) = "template.xls" then
worksheets(1).Cells.Clearcontents
End if
End Sub