VBA code on how to skip macro while not responding

[daniendar]

I have create excel VBA to put data from excel sheet to Server database through network. I create the VBA on the "Workbook_beforeprint" so every time the user print out the sheet, the code will run.
Problem occur when there is no network and excel application become not responding.
I want to make VBA code so that every time excel application become not responding because no network, this code will bypass the excisting VBA and resume to print.
Is anybody can help?

 

[Sthrncali]

It would be helpful if you post your existing before_print code.

 

[daniendar]

thank you Sthrncali,

I already put the existing VBA on before_print.
I want to use "not responding" to trigger my VBA to stop, but I dont know the code for "not responding"
any one can help?

 

[Rick Rothstein]

I already put the existing VBA on before_print.
I want to use "not responding" to trigger my VBA to stop, but I dont know the code for "not responding"
any one can help?

You probably will want to use one of the On Error statements. Which one? Where to put it? What code to use in conjunction with it? I can't say. Why? Because for some reason you don't think we need to see your code.

 

[Kyle123]

Or you need to check for a network connection first. But as Rick says, nothign can be suggested without your code