Link Handling - Programmatically select the option?

[Scotster]

Hi there,

I've had a root around the Application. options and the ThisWorkbook. options but I'm struggling to find any way of switching the "Open supported hyperlinks to Office files in Office desktop apps" on/off.

I have a suite of workbooks on teams with a navigation workbook giving easy access to them. The trouble is that they must open via the app rather than Teams. I found the simplest way to do this is to select this option in the advanced options menu, but I'm wondering if I can programmatically make it happen with the Navigation workbook (so that any further links are opened in the desktop app).

I've done a tutorial for all the users on how to update the flag but just thought it would be neater if the solution was built in.

Appreciate any information