Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving current worksheet on cell value change
Let's say I want the current worksheet to save when the value changes in cell
b15 or b45 or e15, etc. How can I get this done. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving current worksheet on cell value change
one way:
Put this in your worksheet code module (right-click the worksheet tab and choose View Code): Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("B15,B45,E15")) Is Nothing Then _ ThisWorkbook.Save End Sub In article , scotty wrote: Let's say I want the current worksheet to save when the value changes in cell b15 or b45 or e15, etc. How can I get this done. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Change Cell Color if in current Month | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |