We are able to invoke a built-in Ribbon command in VBA by using:
Thank you for the feedback! We’ve added this to our backlog and we’ll keep you posted with status updates.
Office Extensibility Team
Dan Moorehead commented
Office Extensibility Team,
Can you please provide any kind of idea of when or whether this might be implemented (as it's been in the backlog for nearly 2 years)?
Is this something you might be able to move up in the backlog as a higher priority so likely to be addressed?
Application.executeUICommand(command: string | UICommand)
Ideally you could provide an enum like UICommand with string values auto-generated from list of known/most common commands, like from either:
Co-Founder & CTO
PowerSheet.ai for Excel | http://PowerSheet.ai
● AI Powered Excel ● Smart Tables ● Easy BI
● Auto Forms, Reports, Pivot & Finance
● Excel Content Add-in & Online
This relates to "add-in commands"