Dear All,
This may sound ridiculous but is there a way to lock deleting option (right click>delete) but still allow clearing the cell or sheet content. What happen is I get #REF error on formula that link to cells in the this working sheet when other users accidentally do the right click>delete, even if my formula is on another protected sheet.
Thank you,
Pratheep
If you protect the sheet, the only options checked by default are select locked cells and select unlocked cells. make sure delete is not checked. When someone right clicks on a row or column, the delete option is grayed out. Since they can still click in unlocked cells, they can clear them or enter anything they want in them. For that matter you can unlock every cell on the sheet, and still not be able to delete anything.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thank you dflak, that's what i was looking for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks