I have a custom color scheme for a 3d surface map. Fill effects on
cell walls and in legend colors. How can I create a macro that will
modify all surface maps to the same color scheme? Excel 97.
Hi,
Start by recording a macro while you create one of these charts from
scratch. Then post the code you get and someone here should be able to
generalize it.

Signature
Cheers,
Shane Devenshire
> I have a custom color scheme for a 3d surface map. Fill effects on
> cell walls and in legend colors. How can I create a macro that will
> modify all surface maps to the same color scheme? Excel 97.