Worsheet_Change event to all open workbooks

Greetings!

I have a worsheet with a Worksheet_Change event macro. Normally it only works when that worksheet makes change. Is there a way to also make it affect to any changes in all open workbooks?

Thanks

As far as I know you can only do that for the workbook that you have for all the worksheets if you put the code in the ThisWorkbook module .. but not for all open workbooks..

Originally Posted by YasserKhalil

As far as I know you can only do that for the workbook that you have for all the worksheets if you put the code in the ThisWorkbook module .. but not for all open workbooks..

I agree with YasserKhalil on this one

Dear Khaleel and Need4Excel,

Thank you for your help.

All what I wanted is to do a reminder in excel. I have a statup workbook that I wanted to biuld-in with workbook_change event.

will be appreciated if any idea you can extend to me.

Thanks

You can do it using an object that references the application with events

code in thisworkbook module

Please Login or Register  to view this content.

Originally Posted by Andy Pope

You can do it using an object that references the application with events

code in thisworkbook module

Dear Andy, Thank you. That's what i am really looking for.
Thank you again for your support

Cheers

Glad I have learned something new. Thanks a lot Andy Pope for the solution.

This is Awesome Andy.. Thanks for sharing..