I have some worksheets that others have to use. Some cells are unlocked, because the user needs to be able to enter codes or select from a drop-down list. The other cells are locked. For most of the cells containing formulas, I do not want them to be selectable (not really because I don't want users to see the formulas, so much as because I want to constrain selection so that navigating with the arrow keys will guide the user to the next input field).
However, there are some fields (primarily containing totals of the data in the other locked cells) that need to be selectable (to permit the user to copy/paste the values into other documents) but still locked (to prevent overwriting the formulas).
Forcing the users to go to a separate worksheet (where all the cells locked but selectable) to find copyable totals is rather inelegant, and something I would like to avoid.
Thus, in a single protected worksheet, I want there to be a combination of
Cell type . . . Select? . Edit?
Input field . . . Y . . . . Y
Total . . . . . . Y . . . . N
Calculation . . . N . . . . N
I realize that the Protect settings apply to the entire worksheet, but is there a way to set permissions at the cell-level?
I guess I could add a button that runs a macro to toggle the "Select locked cells" permission for the page, but I really prefer not having macros in workbooks I distribute, because it too often seems that, whenever I do include them, there is someone who can't get the sheet to work right -- requiring me to then create new versions with some of the useful features removed. (Well, that, and the security warning messages make the novices worry that something has gone wrong.)
Bookmarks