View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Blue Max Blue Max is offline
external usenet poster
 
Posts: 113
Default Cannot select objects

Hello Dave,

Unfortunately, we have already tried this variation (the button is on the
developer tab in the 2007 ribbon) without success. Any other ideas?

Thanks,
Richard

**************
"Dave Peterson" wrote in message
...
I tested in xl2003...

Try going into design mode. An icon on the developer's tab|insert
group|activeX
section (if I recall correctly).

I'm betting that xl2007 is like xl2003. You can't select the activex
objects
unless you're in design mode.

(I added the Select Objects icon in the Drawing category in the
tools|Customize|Commands tab dialog to do my test.)

Blue Max wrote:

We enable the "Select Objects" feature (Home Tab Find & Select), but
can
never select multiple activeX controls (checkboxes) by dragging the
mouse.
The selection extent (marquee) can be dragged around the objects, but it
will not select them. The selection pane option is no better because we
cannot drag over multiple selections, nor manually extend (SHIFT-Select)
selectons, in the selection pane either.

The only way we can make multiple selections is by CTRL-Selecting objects
on
the worksheet or in the selection pane. Any suggestions why we cannot
drag-select our controls?


--

Dave Peterson