Autorecover interupts macro

[Jo71]

I have two workbooks (a and b), one is referenced to the other (in VB Tools ->references). I have disabled the autorecover for both of the worksheets (in the options -> save.)

However, when i run my macro in (a), the autosave appears halfway through (to save (b)) and when my macro carries on afterwards it is out of sync. I have tried adding

Application.AutoRecover.Enabled = False

at the beginning of my code but it still happens.

Not sure what to check next.

Jo

[Hawkeye16]

Just a shot in the dark but have you tried the Application.EnableEvents = False at the beginning of your code? It pretty much is used for when you have something that runs when a cell is changed and makes it so when the code changes a cell it is not recalled. It may stop whatever is prompting the auto recover. Just an idea.

[Jo71]

This appears to have worked - Thanks Hawkeye16