In . com, Ken
Johnson spake thusly:

[WRT ScreenUpdating/EnableEvents off/on]

Hi Dallman,
Yes, I type it every time.

:-)

You could try...

Public Sub ToggleEvents()
With Application
.ScreenUpdating = Not .ScreenUpdating
.EnableEvents = Not .EnableEvents
End With
End Sub


Ken, that looks simple enough. Much appreciated, also for your
other answer. I will play some more and see how it works out . . . .

=dman=