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

2012-07-31 Thread debdarshan
s 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 >>

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

2012-07-20 Thread debdarshan
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)* *