You can use the Auto_Open procedure. Open the VBA Editor (ALT F11),
insert a Module from the Insert menu, and in that module use


Sub Auto_Open()
ThisWorkbook.Worksheets("Sheet1").Range("A1").Valu e = 0
End Sub

Change the sheet name and cell reference as required.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Thu, 2 Apr 2009 15:00:10 -0700, GEM
wrote:

Is there a way to reset a specific cell to 0 every time the file is opened??