The following line of code opens the Excel Add-ins dialog window (also accessed via ALT-L H):
Application.CommandBars(1).FindControl(ID:=943, Recursive:=True).Execute
Can you please advise a similar line of code which would instead open the COM Add-ins dialog window (also accessed via ALT-L J)?
Please do not suggest SendKeys as this will not work as an alternative solution as the code needs to work when Windows is locked and SendKeys does not work when Windows is locked.
(Note: The ALT keyboard shortcuts above are only given so I can easily explain and identify which dialog box I'm trying to show. Also, note that the ALT-L keyboard shortcut only works if the Develop tab is visible on the ribbon.)
Application.CommandBars(1).FindControl(ID:=943, Recursive:=True).Execute
Can you please advise a similar line of code which would instead open the COM Add-ins dialog window (also accessed via ALT-L J)?
Please do not suggest SendKeys as this will not work as an alternative solution as the code needs to work when Windows is locked and SendKeys does not work when Windows is locked.
(Note: The ALT keyboard shortcuts above are only given so I can easily explain and identify which dialog box I'm trying to show. Also, note that the ALT-L keyboard shortcut only works if the Develop tab is visible on the ribbon.)