Workbook.Active

How can i run a module every time the workbook is active???

my module runs every time the user opens the file, but he want to take it a step further, and let it run every time he 'enters' the workbook!!!

You could take a look at the Workbook_Activate() event handler. You may find that this event isn't raised in every scenario you want it to be.

I had more luck with workbook_WindowActivate event but not much.
Is there any way i can write my own event???