Vba activate screenshot drop-down.

[Nole321]

Hello all,

Currently I have and excel coversheer made and the ribbon and other parts are completely hidden to make a clean experience. Hidden by Application.ExecuteExcel4Macro "show.tpolbar(""Ribbon"",False).

What I am looking for is a way to utilize a function in the ribbon while it's hidden. The function is the screenshot drop-down menu of active screens. Found in insert>illustrations>screenshot. Would anyone know of a way to activate that drop-down menu through vba so I can just use a button?

 

[Nole321]

I found a way to use the idMso. Application.ExecuteMso("Screenshot insert gallery"). But it gives me a run-tike error 5, invalid procedure or call. Anyone know why?