Scotster
Board Regular
- Joined
- May 29, 2017
- Messages
- 59
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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
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