I tried it in xl2000 with windows XP. Clicking the northwest arrow and
rubber banding the controls worked fine. Confirm that Ctrl +Click did not
work. However, shift click did - so minor annoyance.

And yes, you have to be in design mode, but that is what design mode is all
about.

as to the rubber banding not working, perhaps you double clicked in the
spread sheet. This can toggle the northwest arrow.

--
Regards,
Tom Ogilvy


"Susan" wrote in message
oups.com...
whoops. didn't understand the northwest arrow bit. now i see what
you mean. when i click on that it & try rubberbanding it (with the
design mode on & off) it doesn't work.
susan



On Feb 27, 10:01 am, Tom Ogilvy
wrote:
for the rubberband, did you click on the northwest arrrow in the drawing
toolbar to put it in "drawing" mode as well before attempting the
rubberbanding?

--
Regards,
Tom Ogilvy



"Susan" wrote:
yes, i'm using the control toolbox menu.
the option buttons say "=EMBED("Forms.OptionButton.1","")" up in the
formula bar. i'm using excel 2k on windows xp.
i can't select multiples using CTRL+click or dragging a box around
them - in design mode.
susan

On Feb 27, 8:53 am, Andy Pope wrote:
Hi,

I assume you are talking about controls from the Control toolbox?
I was able to select multiple using either the CTRL+click or the
drawing
arrow bounding rectangle.
Where you in design mode when you tried this?

Cheers
Andy

Susan wrote:
i found out you can't select them all like you can when they're on
a
userform...... using Ctrl & clicking on them won't select
multiples.
& you can't highlight & drag around them.......
so i'd be interested in the answer to this question, too. :)
maybe you could write a short macro that loops thru all the option
buttons on the worksheet & changes that property?
susan

On Feb 27, 7:31 am, "Ray" wrote:

Just realized that I failed to set the 'PrintObject' Property to
FALSE
for every button in my workbook -- is there anyway to globally set
this value, without going into each button's properties to update
it?

thanks...
ray

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info-Hide quoted
text -

- Show quoted text -- Hide quoted text -

- Show quoted text -