Yellow message bar

[neu_stone]

Hi everyone.

Sometimes there is yellow message bar below Excel toolbar.
How to get the access to this message bar from AddIn dll.
Is there a pointer like Excel::_MessageBarPtr, as well as Excel::_WorksheetPtr ?

ExcelYellowBar2.png
ExcelYellowBar.png

[S O]

That message bar is in windows explorer, not excel... Do you mean the "Protected View" or "Enable Macros" prompts?

[neu_stone]

Hi S O,
You have good eyes.
"Protected View" is quit like what I am looking for. Is there a way to get the access to "Protected View" prompt?
I need to post messages to "Protected View" prompt, and get user's response via this prompt.

By the way, where may I find any Excel Programming Docs or class manuals?

Thanks,

[S O]

Even if there was a way (which I don't think there is) - those prompts would disable any VBA from running so you wouldn't be able to get a handle on them anyway.

What is the purpose here? May be worth going down the VSTO route instead.

[neu_stone]

Hi SO,
Attached is the message bar which I would like to communicate with. Is it "Protected View" Window ?

My friend is using AfxMessageBox to ask user's selection. This will block working thread.
My idea is to use message bar showing warnings and options without blocking the thread.

I found an API:
Excel::ProtectedViewWindowPtr pWnd = m_pAppExcel->GetProtectedViewWindows();
But pWnd is always nullptr. How to create this wnd ?

Thanks,

ExcelYellowBar3.png

[S O]

What are you using? C++?

[neu_stone]

Yes, I am using C++/MFC.

[neu_stone]

I found how to get dialogs:

Excel::DialogsPtr pDlgs = m_pAppExcel->GetDialogs();
long lNumOfDlgs = pDlgs->GetCount();
Excel::DialogPtr pDlg = pDlgs->GetItem(Excel::xlDialogProtectDocument);

I also found how to get MenuBars:

Excel::MenuBarsPtr pMenuBars = m_pAppExcel->GetMenuBars();
long lCountOfMenubars = pMenuBars->GetCount();
Excel::MenuBarPtr pMenuBar = pMenuBars->GetItem(lIndex);

But still there is no idea of neither ProtectedView nor MessageBar. Might consider to create a modeless dialog by myself to do my job.