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 ?


    Thanks

  • 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.

    Images

    _______________________________________________
    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


    Thanks,
    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!