To figure this out for yourself, see
Case Study €“ Embedded and Linked Objects
http://www.tushar-mehta.com/excel/vb...%20objects.htm

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"mark Stephens" wrote:

Does anyone know how to format a line using excel 2007 built in presets via
vba, as the macro won't capture them?

Thanks and regards, Mark

Does anyone know how to format a line using excel 2007 built in presets via
vba, as the macro won't capture them?

Thanks and regards, Mark

Thanks for that Tushar, appreciate the help, regards, mark

"Tushar Mehta" wrote in
message ...
To figure this out for yourself, see
Case Study - Embedded and Linked Objects
http://www.tushar-mehta.com/excel/vb...%20objects.htm

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"mark Stephens" wrote:

Does anyone know how to format a line using excel 2007 built in presets
via
vba, as the macro won't capture them?

Thanks and regards, Mark