Annoying Autocorrect in Excel 2007 VBA IDE

[Roopher]

Hello there!

Does someone know how to prevent that autocorrect "feature" in the Excel 2007 VBA IDE? It always deletes the last space I type after a second or so, i.e. moving the cursor to the left whenever I stop typing (to think for a moment or so). Grrr.

Thank you!

ps.
(The behaviour is VERY annoying, I guess this "feature" has sneaked into my Excel through these ever-dangerous Windows auto-updates...)

 

[Roopher]

Re: Annoying Autocorrect ... Resolved.

Hello Colin Legg,

I found that turning off the automatic calculation mode in Excel remedies the issue of overly sensitive IDE auto-correct.

The problem became more severe when I use UDFs, but it's gone in manual calculation mode. The switching to/from auto/manual is, for me, much less bugging than the described auto-correct.

Thanks for the replies, Colin & All!

Best regards

 

[Colin Legg]

Okay, because of the types of workbooks I use at work, I always have calcs set to manual. But out of curiousity, didn't toggling BBG realtime updates off fix the problem?

 

[Colin Legg]

Okay, because of the types of workbooks I use at work, I always have calcs set to manual. But out of curiousity, didn't toggling BBG realtime updates off fix the problem?