Warning messages, how to disregarde them?

[richardcranney]

Hi there,

I have a Macro set up which unshares the workbook, runs a VBA script, then shares the workbook again. (I have to do this as the VBA doesnt work when shared)

Is it possible to turn off the dialog messages when sharing? I tried

On Error Resume Next

But this didnt seem to have much effect.

Any help would be much appriciated.

Thanks

Richard

 

[Jonmo1]

This works for me

Application.DisplayAlerts = False