Here's one way to generate a 400 error without a description

- A toolbar button to call a macro in a workbook (eg in Personal)
- Have the wb loaded in one Excel instance but not in a second instance
- In the instance without the wb, press the button to call the macro
- A warning msg will display asking if you want to open the wb as Read-only
(being already open in the other instance)
- Press cancel
- Error 400 !

Regards,
Peter T


"JLGWhiz" wrote in message
...
Hi Peter, I believe you are referring to code 1004. Err 400 is regarding
showing forms modal that are already visible.

"Peter T" wrote:

Err 400 is a generic "Application-defined or object-defined error". In
context the description may be more informative.

Sounds like the error is in your OnTime macro "Auto_Close"macro which you
didn't post. Just step through that macro.

Regards,
Peter T