Hi, i am trying to suppress an error or create my own error event in the case the database is locked. I am using excel to import an external data range, and it autoupdates this lookup. In the case the database is not accessible i want to be able to display my own message. I have tried using the commands

On Error Goto
and
On Error Resume Next

Neither suppress these errors.
Any suggestions?

thanks