$$Excel-Macros$$ Re: Format Shape Style Dialog in XL2007, 2010

2013-11-04 Thread Patrick Toledano
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 sha

$$Excel-Macros$$ Re: Format Shape Style Dialog in XL2007, 2010

2012-07-31 Thread debdarshan
Thanks. I'm not sure I could explain my problem properly. I wish to invoke (using VBA) "Format Shape" built-in DIALOGUE - the one you get by right-clicking on an autoshape placed on a worksheet. D On Sunday, 29 July 2012 06:12:56 UTC+1, TJ wrote: > > Maybe this will help? > http://peltiertech

$$Excel-Macros$$ Re: Format Shape Style Dialog in XL2007, 2010

2012-07-28 Thread TJ
Maybe this will help? http://peltiertech.com/WordPress/programming-excel-2007-2010-autoshapes-with-vba/ On Friday, July 20, 2012 3:56:22 PM UTC-5, debdarshan wrote: > hey! good work... > > i have a question > > How to display the > > *Format > Shape Style Gallery* > ** > **thro