Is there a way to allow users to click on, but not edit, the contents of a cell? I know I can tinker in the settings in Review->Protect Sheet with the "Select Locked Cells" option. But here's the issue: I want to restrict the user from clicking on every other locked cell, just not date cells. Reason is that I want the user to be able to click on a date cell and have a dialog box pop up where they can select a date from a calendar, but not directly edit the cell. So, in summary, I want three types of cells:
- editable, clickable cells
- noneditable, clickable cells
- noneditable, nonclickable cells
Is there some sort of middleground I can use to set some cells as option #2? I've tried various tricks with Application.Undo in the sheet events (which might make this question more fitting for Stackoverflow since that involves VBA) but so far I haven't had any luck.