Manually dragging 3D chart around using mouse

[ghr]

Hello,

I have searched quite a bit but could not find an answer for my problem.

I am using the wonderful code from http://www.doka.ch/Excel3Dscatterplot.htm to represent a 3D chart using the Excel 2D XY Scatter Plot chart.

It comes with scroll bars which allow the graph to be interactively rotated. These work fine. My goal is to make this more intuitive by allowing the user to drag the graph around using their mouse (and therefore remove the scroll bars).

I have succeeded in writing VBA to do this, using a class to capture the chart (it's an embedded one) mouse events and rotate accordingly.

The problem I am having is removing the wireframe rectangle that is painted by Excel itself as I drag the graph around. Visually, it's very annoying so I am really keen to remove it. I am hoping it's not totally built-in and non-hideable.

Here is a screen shot of the graph being dragged with the dashed blue rectangle making its unwanted presence felt.

Many thanks in advance.

 

[smiler]

hi,

This is not an answer but a guide as to where you might need to look,

the 'bounding box' colour is part of the system colour palette and is the 'Selected Items' colour - changing this to the background colour will hide it, but will also set the colour of anything selected to white.

you could change the colour whilst rotating, then set back to its original when the process ends - just an idea

 

[ghr]

Hi Smiler,

Thanks for your thoughts on the matter. After some playing, I understand the following:

The bounding rectangle is indeed coloured by the selected colour, which in Excel is known as SystemColorConstants.vbHighlight.

I confirmed this by comparing the hue numbers in the following image and in both cases, it's 148 (with different saturation and/or luminance levels). Good start.

I confirmed you can change the Excel palette colours using ActiveWorkbook.Colors(color_index) = RGB(r, g, b). Interesting but not useful here.

However, this is where I come unstuck. I am not sure how to change the System colours in Excel.

Can anyone help here?

Or does anyone have any further thoughts to my original issue?

Many thanks!