By default all cells in a worksheet are protected and this is activated by
protecting the sheet. The solution for you is to first un-protect the cells
you want the user to be able to edit by selecting them and then Format -
Cells - protection and removing the Locked checkmark.
Hiding an individual cell is something that I don't believe can be done but
you could create a custom format of ;;; (3 semi colons) for the cell which
will make it appear empty. If when you protect your sheet you remove "Allow
users to select locked cells' it will be as good as invisible.
Mike
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
