Macros - No error, but stops working

[admack]

Hi all,

I am not massively clued up on Macros and am having an issue that I think relates to my settings rather than the macros themselves.

No matter what workbook I open, if it has a macro in it, it will run the macro to a point, then stop, I hit the play button and it completes the script.

No error messages or anything.

Anyone know what it might be. Like I say I have tried it on a number of different sheets - I am using 2007.

Any help would be much appreciated.

Thanks

 

[alansidman]

Suggest you post your code for examination.

Do you have break points set in your code? This is a debugging step that you may have set.

Here is some info on break points if that is the case

Debugging VBA

 

[Andrew Poulsom]

What's the macro and at what point does it stop?

 

[RoryA]

it will run the macro to a point, then stop, I hit the play button and it completes the script.

Does it stop on a line with a Workbooks.Open command in it?