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 -