switching between modes

Hi,

I have a macro running on "break mode" - I didnt set it that way; it
somehow happened.

Now my macro stops midway (when it calls for this sub "statusfill"),
and the VB editor window pops up. I dont want this and want the mode to
be switched back to the normal (or whatever its name is) mode, so that
I can hit ctrl+f and have my complete code run.

Pleeeeeeeeease help!

Thanks,

Joe.

Joe,

This might work.

Run your code. When the VBE pops up, try putting a break point on the line
where it stops, then remove it again and save the file.

I've seen what you are describing happen when a file is saved with a
breakpoint. When it reopens the breakpoint is not visible but still seems to
stop execution.

Robin Hammond
www.enhanceddatasystems.com

"Joe" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a macro running on "break mode" - I didnt set it that way; it
> somehow happened.
>
> Now my macro stops midway (when it calls for this sub "statusfill"),
> and the VB editor window pops up. I dont want this and want the mode to
> be switched back to the normal (or whatever its name is) mode, so that
> I can hit ctrl+f and have my complete code run.
>
> Pleeeeeeeeease help!
>
> Thanks,
>
> Joe.
>

Thanks a lot, Robin ! It was driving me nuts ..lol.. Appreciate your
help.

- Joe.