I've encountered an annoying issue with Windows 11 and Excel 365. I have the following procedure that opens a local .html file in the default browser (currently Edge, but has also been tested in Chrome & FF):
In this case, doubleclicking a field in the userform opens the local .html file as desired. This has worked fine on Excel365/Win10. Two weeks ago, I "upgraded" to Win11, and now, everytime I run this procedure, I am forced to select the target app. Despite Edge being set as the system default, and clicking Always every time, I still have to select it...every time.
I have verified this is limited to Excel, by way of opening one of the target local files via Explorer, which opens as desired without asking. I have been through all Excel options/trust center settings twice to see if something new has popped up, to no avail.
Has anyone else encountered this, and if so, how did you resolve it? Or do you just live with the annoyance?
VBA Code:
Workbooks(strfilenum).FollowHyperlink Address:="C:\Dropbox\FGLOPS\ENTITIES\" & dash_data_entity_shipper & "\" & dash_data_entity_shipper & ".HTML", NewWindow:=TrueIn this case, doubleclicking a field in the userform opens the local .html file as desired. This has worked fine on Excel365/Win10. Two weeks ago, I "upgraded" to Win11, and now, everytime I run this procedure, I am forced to select the target app. Despite Edge being set as the system default, and clicking Always every time, I still have to select it...every time.
I have verified this is limited to Excel, by way of opening one of the target local files via Explorer, which opens as desired without asking. I have been through all Excel options/trust center settings twice to see if something new has popped up, to no avail.
Has anyone else encountered this, and if so, how did you resolve it? Or do you just live with the annoyance?
