| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cannot select objects
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cannot select objects
Sorry, no.
Blue Max wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cannot select objects
Well, maybe one more.
Try it again. Dave Peterson wrote: Sorry, no. Blue Max wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cannot select objects
Hello Dave,
Please note that our testing has now revealed that it is possible to perform a group selection by dragging the mouse cursor, provided the objects are graphics. However, if the objects are controls, then we cannot use this feature. That is very odd since the group select option has as much utility when selecting controls as with graphic objects. We continue to be mystified as to why the user cannot drag and select a group of controls. Thanks, Richard ************* "Dave Peterson" wrote in message ... Well, maybe one more. Try it again. Dave Peterson wrote: Sorry, no. Blue Max wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cannot select objects
I don't have any other guesses.
Sorry. Blue Max wrote: Hello Dave, Please note that our testing has now revealed that it is possible to perform a group selection by dragging the mouse cursor, provided the objects are graphics. However, if the objects are controls, then we cannot use this feature. That is very odd since the group select option has as much utility when selecting controls as with graphic objects. We continue to be mystified as to why the user cannot drag and select a group of controls. Thanks, Richard ************* "Dave Peterson" wrote in message ... Well, maybe one more. Try it again. Dave Peterson wrote: Sorry, no. Blue Max wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot select or move objects. Slash Circle appears. | Excel Discussion (Misc queries) | |||
| Can I select and delete multiple objects from a worksheet? | Excel Discussion (Misc queries) | |||
| Select Objects cursor | Excel Discussion (Misc queries) | |||
| I can't select/edit objects. It says [Group] on the header bar. | Excel Discussion (Misc queries) | |||
| how can I select multiple drawing objects at once | Excel Discussion (Misc queries) | |||
Linear Mode
