don't allow saving in excel

[ozispimp]

i was wondering if there was a way that wouldn't let you modify or save a file.. i know you can do the file save as, then goto general, and make a modify password, but if they modify it, they can save it as another file.

i want it so that they can only fill out the information, print it.. and fax it over.. i don't want them to be able to change and save it.. anyone know of a way?

is there a way to remove the save and save as?

thanks in adv.

 

[JVFriederick]

I don't know of a "good" method to prevent someone from saving a XL file under another name. Some would use a master file to open a protected second file and so on, but . . . .

To prevent someone from saving on top of the original, add the following VB code:

Sub Autpen()
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly ' Switch file to Read only
End Sub