Reseting to 0.
Is there a way to reset a specific cell to 0 every time the file is opened??
|
Reseting to 0.
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 |
Reseting to 0.
hi
in it simplest form.. Private Sub Workbook_Open() Range("A1").Value = 0 'adjust to suit End Sub regards FSt1 "GEM" wrote: Is there a way to reset a specific cell to 0 every time the file is opened?? |
Reseting to 0.
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?? |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com