Built in excel 2007 formats via VBA

[Tushar Mehta]

To figure this out for yourself, see
Case Study – Embedded and Linked Objects
http://www.tushar-mehta.com/excel/vba/vba-embedded or linked objects.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]

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

 

[mark Stephens]

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