View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Cannot select objects

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