I suggest you post your question to the excel.programming newsgroup and show
you code in the message
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Ana via OfficeKB.com" <u51486@uwe wrote in message
news:982b0d5a289f9@uwe...
Thx,but that's not actually what I needed.I need VBA code to put into my
access code so that when I send table from access to excel, I can change
it,
and put white plot area and bold font etc. I have a code for that but it
is
just NOT working and I don't know why. Everything I say like for example
xpAcc.ActiveChart.Legend. Position = xlBottom he just ignore and sets
everything on default (legend position left).
Any ideas?
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200906/1