Hi,
I have a requirement to focus the Add-Ins tab after a excel file is downloaded and opened in VBA macros. But the event is not getting fired on time and Addins tab is not getting focussed. I have tried to do this in Excel Open,Activate, Before Save and After Save events, but none of them helped.
Also I want to make an existing COM addin invisible, but it is not working.
If I have the above two logics in Before save and I do a manual save after the Add-Ins tab is loaded, the functionality is working fine. Add-Ins tab is focussing and COM addin is invisible.
How to solve this issue of achiveing the Add-Ins tab focus and make COM addin invisible after excel is downloaded and opened?
Thanks in advance...
Bookmarks