from 2010 to 2007 vba

Z

ziad alsayed

Well-known Member
Joined
Jul 17, 2010
Messages
665
dear all

long time, hope you are all fine.

i use the below code in 2010 but it seems not working in 2007

Code: 
 With cht.ChartArea.Format.Fill
.ForeColor.ObjectThemeColor = msoThemeColorAccent1
.ForeColor.Brightness = 0.6000000238
        .Transparency = 0.1299999952
 End With

please advise how to make work in 2007
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
You must log in or register to reply here.

Similar threads

O
  • Solved
Why does the first example of code work but second does not? Excel says .ShapeRange.Fill causes Error 438 -- Trying to learn about shapes.
Replies
3
Views
484
DanteAmor
DanteAmor
A
  • Question Question
Object with VBA Code
Replies
8
Views
522
Micron
M
O
  • Solved
How do I to format fill for a picture using VBA?
Replies
3
Views
564
OaklandJim
O
J
  • Question Question
Doughnut chart plot area shrinks on its whim dynamically
Replies
0
Views
397
jammerules
J
C
  • Question Question
How to automatically paste the data from one sheet to another using VBA
Replies
4
Views
278
Alex Blakenburg
A

Forum statistics

Threads
1,224,566
Messages
6,179,555
Members
452,928
Latest member
101blockchains

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top