Drawing Tools expert needed

[Renny Bosch]

This seems to be an area that few Excel users are familiar with: The Drawing
Tools.

I have been using Excel do create some drawings and found the Excel drawing
tools quite powerful. One feature I use is to enable the Selection Pane,
and then move individual shapes more to the front or to the back, to allow
one shape to block another, or vice versa. After using this for a while,
the Reorder buttons have stopped working. What could cause that? How can I
get them back? Is there a limit to how many individual shapes are allowed
in one worksheet or workbook?

The Bring To Front and Send To Back buttons on the Format (Drawing Tools)
ribbon are still working, even the Bring Forward and Send Backward options,
but the Reorder buttons on the Selection Pane are totally unresponsive. So I
haven't completely lost the functionality, just the more convenient way of
invoking it.

Excel 2007, XP with SR3 and all updates.

Thanks for any help -- Renny

 

[Shane Devenshire]

Hi,

I put 100 rectangles into a workbook and could not reproduce your problem.

You can add the Bring Forward or Send Backward tools to the QAT to speed
things up. Choose Drawing Tools, Format, Send to Back and then right click
on the Send Backward button and choose Add to QAT.

 

[Renny Bosch]

Thanks Shane, that worked and, as you say, is a lot more convenient. Still
leaves the mystery of what killed the button functionality but you can't
have everything.

Please consider the Yes button clicked.

Renny

 

[Renny Bosch]

Thanks Shane, that worked and, as you say, is a lot more convenient. Still
leaves the mystery of what killed the button functionality but you can't
have everything.

Please consider the Yes button clicked.

Renny