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. |
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. |
All times are GMT +1. The time now is 08:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com