Damaged workbook jumps worksheets when saving automatically

[Andrew White]

I have a workbook with a little glitch in it. When it pops up the
confirmation dialogue before doing an automatic save it loses track of the
active worksheet and active cell, drops any data being entered into that
cell, and jumps to one particular cell on one particular worksheet. This is
disorienting and there is a real risk entering data wrongly.
Other workbooks don't do this, they gracefully integrate the confirmation
dialogue without interrupting the data entry.
So this workbook must have some slight damage; any ideas how do I repair it?
Many thanks
Andrew White
Exeter UK

 

[mzehr]

Hi Andrew,
It sounds like there might be a Workbook_BeforeSave VBA
event procedure running that could be your problem.
If you disable macros when opening the workbook, does this
event still occur? Go to VBA (Alt+F11) and look in your
VBA project window, "This Workbook" for an event procedure
that has Workbook_BeforeSave call in the code.

HTH