I have some code which should run when I manually focus on excel sheet. This code reads windows clipboard and processes it.
Strangely, Workbook_Activate and Workbook_WindowActivate fire for me only once when workbook is opened. The code in it doesnt involve irrespective of how I focus on it!!
Can someone tell me the workaround and why above events dont work?