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.

switching between modes
 

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" wrote in message
ups.com...
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.

switching between modes
 

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

- Joe.