how to print charts which are embeded in a sheet
 

--------------------------------------------------------------------------------

heloo
i want to print all charts in my sheet
and i want to se the margins of the sheet to all equal to =2 cm
and no footer no header

how through vba?
by the way i use a sub to print a sheet and specifiy the printarea fo
it
and when i use that
ActiveSheet.ChartObjects.PrintOut preview:=True
an error appears
how can i fix that?

--
amrezza
-----------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876
View this thread: http://www.excelforum.com/showthread.php?threadid=54060

how to print charts which are embeded in a sheet
 

Hi,

ActiveSheet.ChartObjects(1).chart.PrintOut preview:=True

Regards,
Ivan