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.
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").
Re: Protect Cells From Deletion
Can you add some code to unprotect while macro is running and then protect when macro is finished running.
Re: Protect Cells From Deletion
Or use the VBA Protect method and protect for UserInterfaceOnly.
Don’t have an account yet? Register yourself now and be a part of our community!