Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Hi,

 

Ofcourse this is possible, you need to use Execute2 and then you can send keys to any dialog with vba

Sub ActivatePhysicalTab()

ThisApplication.CommandManager.ControlDefinitions.Item("AppiPropertiesWrapperCmd").Execute2 (False)
Call SendKeys("{%}")
Call SendKeys("{RIGHT}")
Call SendKeys("{RIGHT}")
Call SendKeys("{RIGHT}")
Call SendKeys("{RIGHT}")
Call SendKeys("{RIGHT}")
Call SendKeys("{RIGHT}")

End Sub
If you think this answer fullfilled your needs, improved your knowledge or leads to a solution,
please feel free to "kudos"