Automation macro within Excel

I'm developing import procedures in VBA Excel for reporting purposes... problem is that the worksheets created by my procedures need to be shared for several users. Now, when I want to add information (transactions) to a sheet, I need to open that sheet, UNSHARE, remove subtotals, add transactions, create subtotals, SHARE and save. Problem is that popup-windows appear with the question 'really want to ...'. I don't want these dialogs (which are generated by Excel) to appear. Can someone help me with this problem? Can I add code into the VBA procedures that will solve this problem? (the used methods are .unprotectSharing and .protectSharing)

Thanks in advance

You can set

Application.DisplayAlerts = False

to stop some excel messages.

Hope this helps.