Hi,
I want to make it impossible for users to edit the content of some cells. However I do want users to be able to delete any row or column, even when these contain the content-protected cells.
I can't figure out how to do this. Can anyone help? Thanks in advance!
If you are only trying to protect few cells, you can in the sheet change event
place code to check whether target cell is the cell you want to protect and display an error message when user tries to change that cell.
Hmm, unfortunately the Change Event is far from waterproof according to a book I have here (Excel 2003 Bible, J. Walkenbach). It claims that there are several ways in which users can still circumvent it. When users use 'Find & Replace' the Change Event will not be triggered for example.Originally Posted by excel_1982
Last edited by Heliux; 04-24-2009 at 08:12 AM. Reason: Forgot to include quote of previous reply
Then maybe try protecting the whole sheet and then protect the cell you dont want the user to edit.
If needed record a macro
I've tried it out, but unfortunately then it becomes impossible to delete a row or column which contains protected cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks