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

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

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

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

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

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

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

Code to Auto Select OK when an Option Box Appears
 

So you are saying the locked macro is the macro that pops up the OK message box
and you cannot edit that macro to quit popping up the OK and just carry on?

And your macro will not work until the OK is acknowledged?

What does the locked macro do after you hit the OK?

End or?

Can you get the unlocker password from whomever locked the VBAProject?


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 13:08:07 -0800,
m wrote:

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