excel vba - shared workbook conflict resolution handling

[gman1979]

Hi guy's,

I’m looking for a way for my userform to deal with conflict resolution dialogue boxes when it's saving to a shared workbook. instead of the conflict resolution dialogue box appearing I’d like to handle this within the vba code in the following way.

if conflict resolution accept all other
message box "advice"
end the sub

i have only been able to find a solution which turns alert boxes of and then on, but that would cause more problems than it would save

any help what so ever would be appreciated.

Thanks

 

[gman1979]

anyone got any ideas on this one???

also looking to clear a listbox of it's contents to run another search but after new search results old ones appear below (if greater number of reults in prev search)