Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell value immediately after a save
Can't you just set it after the save
ThisWorkbook.Save Range("F1").Value=0 Range("F2").Value=0 -- HTH Bob Phillips "cam" wrote in message ... I have this set on a worksheet that initiates a save when either cell F1 or F2 is changed Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False On Error GoTo ws_exit If Not Intersect(Target, Range("f1:f2")) Is Nothing Then ThisWorkbook.Save End If ws_exit: Application.EnableEvents = True End Sub After this save I need the values in cells E2 and F2 to be reset to 0 (the number zero) using code as code changes for some reason do not initiate the save. I need to insure the user changes the value in cell E2 and F2 so that the sheet will save and a RECALL formula I have will update the running total from input in those 2 cells [=RECALL(E2)+E2 and =RECALL(F2)+F2] THANKS!!! in advance for any HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill in Blanks with immediately above cell value | Excel Discussion (Misc queries) | |||
immediately closes when I try to open, error; can't save as, read | Excel Discussion (Misc queries) | |||
Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
Immediately jump to next cell? | Excel Discussion (Misc queries) | |||
Change cell value immediately after a save | Excel Programming |