Hi,

When we are programming Excel, commonly we are programming against the
Excel object modal which will do the similar job as we did in the UI.
Based on my research, the Object modal did not expose such approach to
disable the error dialog.
<Program Files\Microsoft Office\OFFICE11\1033\VBAXL10.CHM

Also can you post a screen shot of the exact error, we may try to see what
cause the error.
e.g. if this is a security error, we can set the security level to low.
Also you may try to disable the autorecover to see if that help you by
following the steps below.
1. click Tools/Options(almost all the excel application level option config
is here)
2. click the Save tab
3. check Disable AutoRecover and restart Excel

Also if there is an local file, if an autorecover occur, will the error
dialog popup?

If you still have any concern, please let me know.

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.