Turning prompts/alerts off and on in excel is easy with:
Application.DisplayAlerts = False
' Your code
Application.DisplayAlerts = True
However, I am working in a shared workbook. When I want to unshare the workbook, i dont want the prompt "am i sure" bit etc.
Adding the bit above, it...