I have a Workbook that gets data from an Access database. I have the workbook refresh this data on open. Everything works great when connected to my work network, or to the vpn. However, when I am not connected to my work network I get prompts for entering network info or to cancel the refresh. I would like to have vba cancel the refresh command if the Access database is unavailable (not connected to the work network) but have been unable to accomplish this as yet. Any ideas?