Forum Discussion
Limit user abilities
We have created a SharePoint site for budgeting (oh what fun) but it will prevent the need to send files back and forth or setting up network locations to have the files stored. When saving files to...
What about sharing the file using a different approach - one that allows you to block download? See: https://support.microsoft.com/en-us/office/block-downloads-for-view-only-files-in-sharepoint-and-onedrive-6051184b-62ac-4149-b874-13dcd40ef91e
Tried and when tested, the problem here is that the file only opens in the on-line browser and the VBA/macros in the file (which hold the security for locking cells / tabs / etc) does not work. Was able to block the "Save as" feature which somewhat works... when they opt to download it opens and they can make changes but when they go to save as it tells them it is disabled. Now, they could simply save the file but not many here know that the file saves to the download folder and even if they do see it in the download folder unless they know how to change the file name by changing it in windows explorer, they cannot change the file name. Really by disabling the save as it makes downloading more trouble than its worth (to me at least). The code used:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
MsgBox "The 'Save As' function has been disabled." & _
Chr(10) & _
Chr(10) & "File location is to remain to be the SharePoint site" & _
Chr(10) & "Please select 'Save' to save the file, otherwise cancel. If a working or test copy of the file is needed, contact either the Controller or Asst. Controller", vbInformation, "Save As Disabled"
Cancel = True
End If
Still would be great to just disable the option to download but still have the file open and edit in excel if possible
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
MsgBox "The 'Save As' function has been disabled." & _
Chr(10) & _
Chr(10) & "File location is to remain to be the SharePoint site" & _
Chr(10) & "Please select 'Save' to save the file, otherwise cancel. If a working or test copy of the file is needed, contact either the Controller or Asst. Controller", vbInformation, "Save As Disabled"
Cancel = True
End If
Still would be great to just disable the option to download but still have the file open and edit in excel if possible