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
.
|