I used Ms.Excel 2000. My worksheet is a share worksheet on server.How can I protected my worksheet from copy by the others ? I've already protected the worksheet with password, but somebody still can do copy from the worksheet to a new worksheet.

Without the use of Macro, there are a few things you can do to protect your worksheet from copying, like specifying a password to open or modify to the whole workbook (this is accessible in Save As...), protect individual worksheets with a password (remember to protect cells in a worksheet as well or else worksheet protection won't work), protect workbook with a password (so that others can't add/delete any worksheet in your workbook). If you know how to use Macro, putting something like this in the Auto_Open() method will prevent anyone from copy any cell other than unprotected cells: Const sPassword as String = "password" Dim ws As Worksheet ThisWorkbook.Unprotect sPassword For Each ws In ThisWorkbook.Worksheets With ws .Unprotect sPassword .EnableSelection = xlUnlockedCells .Visible = xlSheetVisible .Protect sPassword, False, True, True, False End With Next ws By the way, this piece of code works in Excel 97, don't know about Excel 2000 because haven't used it yet. Hope this helps. Mark.

Place the Excel spreadsheet in a folder(Directory) and set the access rights those you want to use it, this way if somebody other than the people that have access to this folder can not access it at all. If you do not have the privileges to do this just have your network admin do it, he or she should be able to help you. We do this all the time at the company I work for. Hope this helps!