View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
 
Posts: 461
Default trouble with selecting ActiveSheet.Shapes.Range

Peter -

Further... The selection handles should distinguish between selection
as a chart + item or just as chartobject.


You're not using 2007, are you? There are not longer selection handles
for a chart or a chart object. Instead, the whole chart acquires a thick
ugly border for an active chart or for a selected chart object (same
appearance for both). It is no longer possible to see by inspection what
is the selection mode.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


Peter T wrote:
Brian,

However I know what you mean by "stuck in
some goofy mode",


Further... The selection handles should distinguish between selection as a
chart + item or just as chartobject. But sometimes when selected as
chartobject, or multiple chartobjects, the full chart type selection handles
are shown. In this phase it can be, though not necessarily, impossible to
manually select additional chartobjects with Ctrl

Well darn! What was working last night is not working tonight.
I just added the following immediately before the Next
statement:
ActiveChart.ChartArea.Select

It's now working, again. I'll hold my breath, keep my fingers crossed
and hope for the best.


That doesn't reliably work for me. If/when you can infallibly reproduce a
workaround do post back, or if that's sometime in the future could you nudge
me off-line (address disguised in the reply-to field)

Regards,
Peter T

"Brian Murphy" wrote in message
...
Peter,

I think I see why my post was a hard to follow. "is working normally"
was supposed to be "is not working normally"

Your suggestion is a good one. I will put in the extra logic to trap
wayward cases.

Well darn! What was working last night is not working tonight. Back
to the same monkey business with not showing all charts as being
selected even though they are. No idea why. Might be the phase of
the moon, or maybe because it's Friday.

As one might guess, right before this selecting stuff a loop operates
on each selected chart (to change the data displayed and some
formats). I just added the following immediately before the Next
statement:
ActiveChart.ChartArea.Select

It's now working, again. I'll hold my breath, keep my fingers crossed
and hope for the best.

Still have to make sure the code works in excel 2003.

Onward through the fog,

Brian


On Oct 16, 3:16 am, "Peter T" <peter_t@discussions wrote:
Not sure I quite follow all that, you can't have an activechart and
multiple
charts selected at the same time? However I know what you mean by "stuck
in
some goofy mode", that can be recreated manually and once in it almost
impossible to break out of (and be able to visually show correct
selection
of multiple charts).