protect the worksheet
 

I did a excel file for work, what i want is everybody can open it, but
they can't save(save as) or copy it. how can do that?
Thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=538719

protect the worksheet
 

here's one from J-Walk's excel for dummies

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
MsgBox "You Cannot save a copy of this workbook!"
Cancel = True
End If
End Sub

this goes into a workbook module, search excel help if you need to find
it

this won't let you save the workbook when you are in excel......


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=538719