D
DonS
We just upgraded to Office 2004 for Mac. One of our VBA programs is
now misbehaving. Unlike with the PC and earlier Mac versions of
Excel, the default option for creating bubble charts in Excel 2004
seems to create bubbles with drop shadows. You can remove the
shadows interactively. You should be able to remove the shadows using
VBA (SERIES.SHADOW=FALSE). But there seems to be a bug and it won't
work. Even if you Macro-record yourself deleting the drop-shadows
interactively, the macro won't replicate the deletion.
Why do we care about this? The key chart in software that we provide
our clients is a bubble chart, created by our VBA macros. We use
hollow (no interior fill) bubbles. We use the no-fill bubbles to let
you see what's underneath the bubble (e.g. other bubbles). However,
when the bubbles have shadows, the shadow fills the interior of the
hollow bubble, obscuring information underneath.
As far as I know, this is only an issue with Excel 2004 for Mac. Has
anyone else seen this? Any ideas for a work-around? Thanks.
now misbehaving. Unlike with the PC and earlier Mac versions of
Excel, the default option for creating bubble charts in Excel 2004
seems to create bubbles with drop shadows. You can remove the
shadows interactively. You should be able to remove the shadows using
VBA (SERIES.SHADOW=FALSE). But there seems to be a bug and it won't
work. Even if you Macro-record yourself deleting the drop-shadows
interactively, the macro won't replicate the deletion.
Why do we care about this? The key chart in software that we provide
our clients is a bubble chart, created by our VBA macros. We use
hollow (no interior fill) bubbles. We use the no-fill bubbles to let
you see what's underneath the bubble (e.g. other bubbles). However,
when the bubbles have shadows, the shadow fills the interior of the
hollow bubble, obscuring information underneath.
As far as I know, this is only an issue with Excel 2004 for Mac. Has
anyone else seen this? Any ideas for a work-around? Thanks.