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