Globally update button properties?
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 |
Globally update button properties?
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 |
Globally update button properties?
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 |
Globally update button properties?
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 - |
Globally update button properties?
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 - |
Globally update button properties?
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 |
Globally update button properties?
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 - |
Globally update button properties?
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 |
Globally update button properties?
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 - |
Globally update button properties?
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 - |
Globally update button properties?
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 - |
Globally update button properties?
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 - |
Globally update button properties?
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 - |
Globally update button properties?
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 |
Globally update button properties?
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 |
Globally update button properties?
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 |
Globally update button properties?
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 |
Globally update button properties?
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 - |
Globally update button properties?
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 |
Globally update button properties?
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 |
Globally update button properties?
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 |
Globally update button properties?
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 - |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com