I've the same problem and investigate by a complete scan of menubars,
commandbars and controls/subcontrols...
But nothing in thousands of IDs
But, I believe this dialog is not accessible thru Worksheet Id:=1, but by
another "root" bar...
When use 1,... we access to format... cells dialog not shapes format dialog.
I try also by Alt+Key to find the right keys to access Format Shape Dialog
where is "*WJ*"...
Now how to send keys (I've used SendKeys without success), and after the
main ShapeFormat menu, how to access to dialog (NO key...)
Le vendredi 20 juillet 2012 22:56:22 UTC+2, debdarshan a écrit :
>
> hey! good work...
>
> i have a question....
>
> How to display the
>
> *Format > Shape Style Gallery*
> **
> **through VBA - i.e. in the lines of
>
>
> *1. Application.Dialogs(xlDialogFormatFont).Show*
> *2. Set Cmd = Application.CommandBars(1).FindControl _*
> * (Type:=1, ID:=256, Recursive:=True)*
> * Cmd.Execute*
> *3. CommandBars.FindControl(ID:=70).Execute*
> *4. CommandBars("Worksheet Menu Bar").Controls("Format").Controls("Format
> Shape...").Execute*
> *5. CommandBars("Cell").Controls("Format Shape...").Execute*
>
> etc. etc...
>
> I understand it is a RibbonX Gallery item, and may not be available
> through the "PolicyID" listed in MS Support:
>
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=4329d9e9-4d11-46a5-898d-23e4f331e9ae&DisplayLang=en
>
> Can you confirm? Does VBA (native) has access to RibbonX Gallery?
>
> Thanks....
>
> D
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
