Hei!

My problem is following. My macro uses another macro created by other
person. I cannot modify or even see the macro. After compliting that
other macro I get msgbox telling me it is done. Now I want to answer
that message automatically with macro. How can I do this?

code is something like this

'myCode
call problemMacro
'problemMacro code which I can't see
msgbox("Refresh succeeded") <- I want to automatically answer yes
'more code I can't see
'myCode

You can't answer a msgbox that way. The only thing that would work is to
remove the code line that creates the msgbox. If you can't see the code,
then you can't do that either. If you can't see the code, then it is
password protected, which means you can't add more code to answer it with
even if there were such a code. You're stuck with it! (you can buy a
password remover.)

Mike F
"HI" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hei!
>
> My problem is following. My macro uses another macro created by other
> person. I cannot modify or even see the macro. After compliting that
> other macro I get msgbox telling me it is done. Now I want to answer
> that message automatically with macro. How can I do this?
>
> code is something like this
>
> 'myCode
> call problemMacro
> 'problemMacro code which I can't see
> msgbox("Refresh succeeded") <- I want to automatically answer yes
> 'more code I can't see
> 'myCode
>

Thanks, Mike!
This problem was driving me nuts. Basicly the msgbox is created by an
add-in which is indeed protected. So I guess I just tell people in my
office to push that damn putton to complite the macro.

On 14 syys, 17:40, "Mike Fogleman" <mikefogle...@insightbb.com> wrote:
> You can't answer a msgbox that way. The only thing that would work is to
> remove the code line that creates the msgbox. If you can't see the code,
> then you can't do that either. If you can't see the code, then it is
> password protected, which means you can't add more code to answer it with
> even if there were such a code. You're stuck with it! (you can buy a
> password remover.)
>
> Mike F"HI" <Ikola_...@hotmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > Hei!
>
> > My problem is following. My macro uses another macro created by other
> > person. I cannot modify or even see the macro. After compliting that
> > other macro I get msgbox telling me it is done. Now I want to answer
> > that message automatically with macro. How can I do this?
>
> > code is something like this
>
> > 'myCode
> > call problemMacro
> > 'problemMacro code which I can't see
> > msgbox("Refresh succeeded") <- I want to automatically answer yes
> > 'more code I can't see
> > 'myCode- Piilota siteerattu teksti -
>
> - Näytä siteerattu teksti -