Event Handlers

[raphoe]

I have an excel application called Wages, I have coded some of the ThisWorkbook event handlers for this application. My problem is that when another excel workbook is opened, the event handlers in Wages are triggered, sometimes causing a crash. Is there any way to stop the events in Wages being triggered by other excel applications.

Raphoe

 

[DRJ]

Hi welcome to the board

Try something like this. at the begging of each event put

if activeworkbook.name = thisworkbook.name then
event code here
else
end if

This way the code will only execute if your workbook is active, if another workbook is active it will not execute.

Hope this helps

Jacob