Copy/Paste and Events problem

[Des]

To use copy/paste I have to turn off Events. On all my workbooks that have events, I have to include a button, "Events off/on". Its a pain.
This is not a new problem I am having but I'm wondering if it is just a feature of Excel and I have to put up with it.
Help appreciated.

 

[Kaper]

As long as you do not have anything special in your workbook, you do not have to switch events Off/ON

If there is such requirement - insert in your copying procedure switching off and on, like:

'code of your copying begins here
application.enableevents = false
'real copying code, which would trigger events if not disabled goes here
application.enableevents = true
'the end of copying procedure, or other instructions, which will not trigger any events

 

[Des]

As long as you do not have anything special in your workbook, you do not have to switch events Off/ON

If there is such requirement - insert in your copying procedure switching off and on, like:

'code of your copying begins here
application.enableevents = false
'real copying code, which would trigger events if not disabled goes here
application.enableevents = true
'the end of copying procedure, or other instructions, which will not trigger any events

Thanks, but it is not vba copy/paste code, its just the normal copy paste while using the worksheet.