A simple solution could be to copy paste values to a different worksheet at
the end of your subroutine.
Or maybe
Application.DisplayAlerts = False
based on a paritcular event, on Exit

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Roopa" wrote:

Hi,
I am using Activeworkbook.Refreshall in one of my functions.
But when I go offline its displaying dialog box "Microsoft Access Database
Engine" to connect again.
But I want to disable the dialog box or close the connection if I go offline.
Can anybody let me know how i can do this?
Thanks.