Disable saving

[jboles]

Good Day,

I need to know ho wto disable saving local copies of excel files that are distributed on sharepoint portal sites.

The workbook is protected, and SPS settings are read-only, but the information is sensitive and we want users to interact with the file but NOT save copies of it...

 

[DominicB]

Good afternoon jboles

A piece of simple code like this will halt ANY attempt to save the file. It needs to be copied into the ThisWorkbook part of a project to work properly. However, it will also bring it's own problems in that a user must say yes to running a file with macros.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
MsgBox "You cannot save this file"
End Sub

HTH

DominicB