Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
optionbuttons
Is there a code that will clear all checked optionbuttons
to unchecked, without having to list them all? Also with vbYesNo how do you bring up No as the highlighted option, not Yes. Finally,as I have set the required toolbars, is there a way to stop a user from minimising windows on the taskbar and then maximising the window as it re-appears with a different set of toolbars. Thanks for your help with this; I think I've cracked the project once I've got this. Thanks again. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
optionbuttons
for control toolbox toolbar buttons on a worksheet
for each oleObj in ActiveSheet.OleObjects if typeof oleObj.Object is MSforms.OptionButton then oleObj.Object.Value = False End if Next ------- msgbox "Yes or No", vbDefaultButton2+vbYesNo ------- I don't have a pat answer for the last. Regards, Tom Ogilvy "Phil Perry" wrote in message ... Is there a code that will clear all checked optionbuttons to unchecked, without having to list them all? Also with vbYesNo how do you bring up No as the highlighted option, not Yes. Finally,as I have set the required toolbars, is there a way to stop a user from minimising windows on the taskbar and then maximising the window as it re-appears with a different set of toolbars. Thanks for your help with this; I think I've cracked the project once I've got this. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm OptionButtons | Excel Discussion (Misc queries) | |||
Control ToolBox OptionButtons? | Excel Discussion (Misc queries) | |||
Control ToolBox OptionButtons Printing? | Excel Discussion (Misc queries) | |||
Moving OptionButtons | Excel Discussion (Misc queries) |