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

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

On Feb 27, 7:57 am, "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

I saw the same thing Susan. Globally updating these properties would
be of GREAT help, as of course you could expand the idea to other
properties (ie Font, positioning, etc).

Can an MVP help us out...?

TIA, Ray

sorry i wasn't much help................... :D

i came up with this:

Option Explicit

Private Sub change_the_property()

Dim oControl As Control
Dim ws As Worksheet

ws = ActiveSheet

With ws
For Each oControl In Controls
If TypeOf oControl Is msforms.OptionButton Then
oControl.PrintObject.Value = True
End If
Next oControl
End With

End Sub


& i think it would work but i have to search the newsgroup & see what
the proper syntax is
For Each oControl in CONTROLS
because it keeps erroring on that line..... in a userform it's
me.controls & i tried ws.controls but haven't gotten it yet.
:)
susan


On Feb 27, 8:04 am, "Ray" wrote:
On Feb 27, 7:57 am, "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

I saw the same thing Susan. Globally updating these properties would
be of GREAT help, as of course you could expand the idea to other
properties (ie Font, positioning, etc).

Can an MVP help us out...?

TIA, Ray- Hide quoted text -

- Show quoted text -

this worked!

Option Explicit

Private Sub change_the_property()

Dim oControl As OLEObject
Dim ws As Worksheet

Set ws = ActiveSheet

For Each oControl In ws.OLEObjects

If TypeName(oControl.Object) = "OptionButton" Then
With oControl
.PrintObject = False
End With

End If
Next oControl

End Sub


very speedy, too.
hope it works for you!
susan


On Feb 27, 8:15 am, "Susan" wrote:
sorry i wasn't much help................... :D

i came up with this:

Option Explicit

Private Sub change_the_property()

Dim oControl As Control
Dim ws As Worksheet

ws = ActiveSheet

With ws
For Each oControl In Controls
If TypeOf oControl Is msforms.OptionButton Then
oControl.PrintObject.Value = True
End If
Next oControl
End With

End Sub

& i think it would work but i have to search the newsgroup & see what
the proper syntax is
For Each oControl in CONTROLS
because it keeps erroring on that line..... in a userform it's
me.controls & i tried ws.controls but haven't gotten it yet.
:)
susan

On Feb 27, 8:04 am, "Ray" wrote:



On Feb 27, 7:57 am, "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

I saw the same thing Susan. Globally updating these properties would
be of GREAT help, as of course you could expand the idea to other
properties (ie Font, positioning, etc).

Can an MVP help us out...?

TIA, Ray- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

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 - Excel
http://www.andypope.info

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 -

very strange. Although in xl2k you need to use SHIFT+Click to multi
select. But the bounding selection should still work.

No sheet protection going on is there?

Cheers
Andy

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 -




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

aha. shift+control+click works to multi-select.
shift+click also works.
but ctrl+click works on userforms & other things, like cells, so......
i dunno.
:)
no sheet protection (on mine) cuz it was a brand-new book1 i started
to test this out.
thanks for your help...... now ray can either do it manually or use
the macro.
susan



Feb 27, 9:20 am, Andy Pope wrote:
very strange. Although in xl2k you need to use SHIFT+Click to multi
select. But the bounding selection should still work.

No sheet protection going on is there?

Cheers
Andy





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 -

--

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

- Show quoted text -

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 -

yes. the ruler-pencil-triangle button.
:)
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 -

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 -

I know doing that has worked for me from xl95 forward with Win95, Win98SE and
Win XP. All objects on the drawing plane are selected within the
rubberbanded rectangle.

--
Regards,
Tom Ogilvy


"Susan" wrote:

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 -

One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson

cool............ note - have to be in design mode for it to work.
thanks!
susan

On Feb 27, 10:52 am, Dave Peterson wrote:
One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson

But you have to be in design mode for the other stuff to work, too.

Susan wrote:

cool............ note - have to be in design mode for it to work.
thanks!
susan

On Feb 27, 10:52 am, Dave Peterson wrote:
One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson

--

Dave Peterson

On Feb 27, 11:04 am, "Susan" wrote:
cool............ note - have to be in design mode for it to work.
thanks!
susan

On Feb 27, 10:52 am, Dave Peterson wrote:

One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson

Thanks Susan .... your code solution worked exactly as I wanted it
to! Now, to find a list of the Property Names that can be updated
with this code... ;)

Ray

yes. but i wasn't after i added the button so at first it wouldn't
work. so i just thought i'd mention it for future readers.
:D


On Feb 27, 11:08 am, Dave Peterson wrote:
But you have to be in design mode for the other stuff to work, too.





Susan wrote:

cool............ note - have to be in design mode for it to work.
thanks!
susan

On Feb 27, 10:52 am, Dave Peterson wrote:
One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Do you need that button to select multiple objects on your machine Dave?
Just curious.

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote:

One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson

Nope. I just click and ctrl-click or just lasso them with that pointer icon on
the drawing toolbar. I actually added to my toolbar before I posted--just to
make sure it worked <bg.

But I could see how it could be a benefit if the shapes are spread out all over
the worksheet.

Tom Ogilvy wrote:

Do you need that button to select multiple objects on your machine Dave?
Just curious.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote:

One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson


--

Dave Peterson

Just taking a survey <g. Thanks.

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote:

Nope. I just click and ctrl-click or just lasso them with that pointer icon on
the drawing toolbar. I actually added to my toolbar before I posted--just to
make sure it worked <bg.

But I could see how it could be a benefit if the shapes are spread out all over
the worksheet.

Tom Ogilvy wrote:

Do you need that button to select multiple objects on your machine Dave?
Just curious.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote:

One more way to select multiple objects

Tools|Customize|Commands Tab|Drawing Category
Choose Select Multiple Objects

Drag that icon to your favorite toolbar.

You can select all and deselect the ones you want--or just select each.

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

--

Dave Peterson


--

Dave Peterson

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 -