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