but in Excel 2007 the line of code does nothing.

Not so for me. With a line selected I get the "Format Object" dialog which
appears to be the same thing as the "Format AutoShape" dialog in Excel 2003.


--
Jim
"Laura Battarbee" wrote in
message ...
| Thanks Jim.
|
| Tried it in VBA too...
|
| With a line object selected I am able to run the code
| "Application.Dialogs(xlDialogPatterns).Show" in Excel 2003, but in Excel
2007
| the line of code does nothing.
|
| I think the dialog box has changed between the versions. For example in
| 2003 the dialog box has the title "Format AutoShape" whereas in 2007 it
says
| "Format Shape" and has a lot more going on in it (has the line style tab
| selected).
|
| Anyone know how to call the 2007 dialog box?