Protect Cells From Deletion

  • Hi,

    I would like to protect some cells of a spreadsheet, without using Excel's protection, because I only want to prevent the deletion of those cells - the cells must remain editable.
    Any idea ?


  • Re: Protect Cells From Deletion

    In Excel 2003, you can lock/protect the sheet to prevent deletion of cells, but still allow the cells to be editable.

    See attached image.


    There are 10 types of people in the world. Those that understand Binary and those that dont. :P

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)


  • Re: Protect Cells From Deletion

    But it doesn't solve my problem, because the cells that I want to protect are used by a VBA program. If I do as you suggest, then my program doesn't run any more (I have the following error message: "Run-time error 1004 Application-defined or object-defined error").

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!