Posted: Wed Nov 19, 2008 9:58 pm Post subject: Saving worksheet
When I close my worksheet and reopen it this formula no longer works is there a special way to close out. When I create this sheet it works great
I relize I must set macros at low or medium settings but do I have to leave the security set low for this to work without continuously changing it as I would prefer to keep a high security setting
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Dim rng As Range
' Only look at single cell changes
If Target.Count > 1 Then Exit Sub
Set rng = Target
' Only look at that range
If Intersect(Target, rng) Is Nothing Then Exit Sub
' Add A2's value to B2
Target.Offset(0, 1).Value = Target.Offset(0, 1).Value + Target.Value
Application.EnableEvents = True
End Sub
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum