Add following in the code module for thisworkbook...


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

user's can of course circumvent this by disabling events or macro's
but in most cases it will do nicely.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"YB" wrote:

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