You could use the BeforeClose Event to stop saves.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Me.ReadOnly Then Me.Saved = True
End Sub


--JP

On Sep 23, 11:56*am, Chilired
wrote:
A protected read-only file resides on our Intranet. *The user opens, sorts
data, view file etc.; however upon closing Excel ask "Do you want to Save the
Changes you made to File Name". *How may I stop this from happening? *

Thanks,