| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code to Auto Select OK when an Option Box Appears
Is there any code than can be put into vba that will automatically select ok
when an info box appears asking Ok, Cancel, or help? I need ok to be automatically selected or else my macro is useless. Thanks Adam Bush |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to Auto Select OK when an Option Box Appears
then why display the info? box at all why not simply
response =vbOk and crack on with whatever you were doing Mike " wrote: Is there any code than can be put into vba that will automatically select ok when an info box appears asking Ok, Cancel, or help? I need ok to be automatically selected or else my macro is useless. Thanks Adam Bush |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to Auto Select OK when an Option Box Appears
Mike,
The problem is my macro is running another macro that has locked code. Therefore, I can't just make this change. ANy other ideas? Thanks Adam Bush "Mike H" wrote: then why display the info? box at all why not simply response =vbOk and crack on with whatever you were doing Mike " wrote: Is there any code than can be put into vba that will automatically select ok when an info box appears asking Ok, Cancel, or help? I need ok to be automatically selected or else my macro is useless. Thanks Adam Bush |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to Auto Select OK when an Option Box Appears
Hi,
I think you have a fundamental problem in that even if it were possible it would probably only be so by getting into the code from where the infobox!! is called from. As you currently describe your problem that code is unavailable to you and is waiting for a click and there is in my view little you can do about that but other respondents may differ. Mike " wrote: Mike, The problem is my macro is running another macro that has locked code. Therefore, I can't just make this change. ANy other ideas? Thanks Adam Bush "Mike H" wrote: then why display the info? box at all why not simply response =vbOk and crack on with whatever you were doing Mike " wrote: Is there any code than can be put into vba that will automatically select ok when an info box appears asking Ok, Cancel, or help? I need ok to be automatically selected or else my macro is useless. Thanks Adam Bush |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to Auto Select OK when an Option Box Appears
Mike,
IS there anyway to automatically say OK to anything that pops up, no matter what it is or what the source is? Thanks Adam Bush "Mike H" wrote: Hi, I think you have a fundamental problem in that even if it were possible it would probably only be so by getting into the code from where the infobox!! is called from. As you currently describe your problem that code is unavailable to you and is waiting for a click and there is in my view little you can do about that but other respondents may differ. Mike " wrote: Mike, The problem is my macro is running another macro that has locked code. Therefore, I can't just make this change. ANy other ideas? Thanks Adam Bush "Mike H" wrote: then why display the info? box at all why not simply response =vbOk and crack on with whatever you were doing Mike " wrote: Is there any code than can be put into vba that will automatically select ok when an info box appears asking Ok, Cancel, or help? I need ok to be automatically selected or else my macro is useless. Thanks Adam Bush |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to Auto Select OK when an Option Box Appears
Hi again,
I don't know of any way to do that so i think you will have to see if others have any ideas. Mike " wrote: Mike, IS there anyway to automatically say OK to anything that pops up, no matter what it is or what the source is? Thanks Adam Bush "Mike H" wrote: Hi, I think you have a fundamental problem in that even if it were possible it would probably only be so by getting into the code from where the infobox!! is called from. As you currently describe your problem that code is unavailable to you and is waiting for a click and there is in my view little you can do about that but other respondents may differ. Mike " wrote: Mike, The problem is my macro is running another macro that has locked code. Therefore, I can't just make this change. ANy other ideas? Thanks Adam Bush "Mike H" wrote: then why display the info? box at all why not simply response =vbOk and crack on with whatever you were doing Mike " wrote: Is there any code than can be put into vba that will automatically select ok when an info box appears asking Ok, Cancel, or help? I need ok to be automatically selected or else my macro is useless. Thanks Adam Bush |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to Auto Select OK when an Option Box Appears
Ok well thanks for your help Mike.
"Mike H" wrote: Hi again, I don't know of any way to do that so i think you will have to see if others have any ideas. Mike " wrote: Mike, IS there anyway to automatically say OK to anything that pops up, no matter what it is or what the source is? Thanks Adam Bush "Mike H" wrote: Hi, I think you have a fundamental problem in that even if it were possible it would probably only be so by getting into the code from where the infobox!! is called from. As you currently describe your problem that code is unavailable to you and is waiting for a click and there is in my view little you can do about that but other respondents may differ. Mike " wrote: Mike, The problem is my macro is running another macro that has locked code. Therefore, I can't just make this change. ANy other ideas? Thanks Adam Bush "Mike H" wrote: then why display the info? box at all why not simply response =vbOk and crack on with whatever you were doing Mike " wrote: Is there any code than can be put into vba that will automatically select ok when an info box appears asking Ok, Cancel, or help? I need ok to be automatically selected or else my macro is useless. Thanks Adam Bush |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot select or move objects. Slash Circle appears. | Excel Discussion (Misc queries) | |||
| Can I select more than one option in a drop down box? | Excel Discussion (Misc queries) | |||
| List Box Multi Select Option | Excel Worksheet Functions | |||
| How do I count how many times a code appears in a column? | Excel Worksheet Functions | |||
| How can I select to print on 11 x 17 paper? It is not an option . | Excel Discussion (Misc queries) | |||
Linear Mode
