Enabling and Disabling Events

[Shay A]

Hi,
I would like to create a macro that toggles events on and off.
Thank you for your help in advance.

 

[vletm]

Shay A
Something like this ...

Sub Swaps_E()
    With Application
        .EnableEvents = Not .EnableEvents
    End With
End Sub

 

[Shay A]

Thanks but how does it enable the user to turn events on/off? What about vbyes and vnno within a message box?

 

[vletm]

Shay A
How:
Run once - it will change status
Run again - it will change status

What:
You asked something,
... and now You would like to get something else/more?

 

[Shay A]

So the first code is enough to enable/disable events? If, so ignore my previous message.

TY

 

[Shay A]

*If so

 

[vletm]

Shay A
How?
You wrote something and
I read it already.
... and You even didn't use it.
What would be Your point?

 

[Shay A]

Becuse I didn't quite understand it, only after my second posting.
SORRY