I had this issue a couple of weeks ago, but for some reason (possibly an update) it seems to have stopped.
As my code was running, for no apparent reason this dialog kept popping up. It seemed especially prelavent when writing data to cells. In the end I had to wrap all my writes with
‘Application.EnableCancelKey = xlDisabled
wsLogging.Cells(m_outrow, col).Value = wsLogging.Cells(m_outrow, col).Value & ” | ” & message
‘Application.EnableCancelKey = xlInterrupt
Anyone else bothered by this? I was going to try cleaning the code, but now it seems to have gone away. Or possibly it was someone elses code, and/or some interference from another addin? Whatever, I can’t seem to repro the behavior anymore.
If it makes any difference I am using a multilingual Office (2007 – 12.0.6550.5004).
so I am curious, did anyone else see this problem? did you work out what caused it? did you find a better workaround? has it fixed itself?