We have a Excel COM Addin which has a button. On button click, we are setting the caption of the active window
and then perform workbook.Activate. The issue is after setting the application.ActiveWindow.caption, subsequent calls of ActiveWorkbook.Activate event is activating the first sheet of excel no matter which sheet is on focus. That means if excel workbook has 3 sheets and currently 3rd sheet is active, when I click on the button first sheet is getting activated.
Has anyone seen this kind of issue before. Is there any solution or workaround for this issue.
Thanks in advance