Worksheet Naming

  • Thread starter Thread starter Andy Sandford
  • Start date Start date
Actually, when I said there is probably nothing wrong with disabling events,
I had given some thought to the calculate event and my feeling would be that
disabling might be a disadvantage in this case. Obviously it would depend
on the particulars.
 
Then a principle might be to not do something if it isn't required
particularly if it has side effects.

The principle of disabling events when performing an action that would cause
a recursive call is certainly sound.

However, under that principle

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
if Target.Address = $A$1 then
Target.Offset(0,1).Value = Date
end if
End Sub

Would cause a recursive call, but I wouldn't see a need to disable events in
this instance.

Of course each person is free to do whatever they want.
 
Back
Top