Can the Excel 365 stock quote disclaimer message be defeated?

[DigitalCyclist]

When opening a workbook that uses the Excel 365 stock quote function, the message bar pops up with "DISCLAIMER: Financial market information…"

Is there a way to defeat this message from popping up, either through settings or a VBA-set attribute?

Note: the protected content message settings in trust center options have no effect on this.
Thanks!

 

[smozgur]

Welcome to the MrExcel Message Board!

It looks like the disclaimer message is working as designed for the Stock data type and related functions according to some discussion in the Microsoft community forums.
However, there is a suggestion about it that you can vote for in the Excel UserVoice.

UserVoice Pages

excel.uservoice.com

 

[DigitalCyclist]

Is that "warning banner" on the Excel sheet a defined object? I've had no success in trying to determine whether it is or not. If it is, then perhaps it can be programmatically made to disappear if present?

(I did see the thread in the Microsoft community forum and I did add my vote to it.)

 

[smozgur]

It is surely an object, but I don't think it is an object that is exposed in the Excel object model that is accessible through VBA.

On the other side, it should be possible to access the controls in an external application window by using the Windows API (since everything is a window in Windows OS, the Windows API can access all windows that you can acquire the window handle (hWnd). I haven't been practicing Windows platform development for a while, so I am not sure what it would require even it might be possible.

 

[DigitalCyclist]

It is surely an object, but I don't think it is an object that is exposed in the Excel object model that is accessible through VBA.

On the other side, it should be possible to access the controls in an external application window by using the Windows API (since everything is a window in Windows OS, the Windows API can access all windows that you can acquire the window handle (hWnd). I haven't been practicing Windows platform development for a while, so I am not sure what it would require even it might be possible.

Yes, for sure it can be done by going through the Windows API and using mouse controls. Somehow that just doesn't seem worth the effort. I also deal with a hands-free environment and can embed in my VBA code a call out to the Dragon software to click on the banner and close it. Again though, doesn't seem worth the effort. Oh well. Thanks for the suggestion.

 

[smozgur]

that just doesn't seem worth the effort

Wanted to mention that in my earlier post but I wasn’t sure if it does or not for your requirements. I totally agree.

Perhaps MS considers to make it an optional setting