You can use a macro -- but that would only work if macros are enabled by the
user.
Option Explicit
Sub Auto_Open()
thisworkbook.worksheets("Somesheetnamehere").range ("x99").value = 0
End sub
If you're new to macros:
Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html
David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm
(General, Regular and Standard modules all describe the same thing.)
GEM wrote:
Is there a way to reset a specific cell to 0 every time the file is opened??
--
Dave Peterson