Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reseting to 0.
Is there a way to reset a specific cell to 0 every time the file is opened??
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reseting named ranges. | Excel Discussion (Misc queries) | |||
VBA reseting variables | Excel Discussion (Misc queries) | |||
VBA reseting variables | Excel Discussion (Misc queries) | |||
Manually reseting the used cell range | Excel Discussion (Misc queries) | |||
name box reseting | Excel Discussion (Misc queries) |