View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stewart[_3_] Stewart[_3_] is offline
external usenet poster
 
Posts: 8
Default Restricting save ability of an excel file

I'm not 100% sure but try this go to the workbook module
on visual basic editor and put in this code:-

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
Cancel = True
End Sub

please note that the cancel... line should be included in
the top line of code

I hope that works

Stewart Walker
-----Original Message-----
Hi there,
I'd like to give access to a wide range of users to an

excel file.
They should have all the usual rights to use the excel

file except that they
should not be able to save the file on their computer or

elsewhere. This
file would and should only remain on a server and never

save else where by
common users.
Is there a simple method to unable the save or save as

ability of an excel
file ?
Thanks,
YB


.