I've got a fun one today!
I have a macro-enabled workbook with a dropdown menu that pulls in staff names from another sheet. This sheet has many protected cells, but the cells where one would type in content to search for a staff member or click the dropdown menu are unlocked (I've checked.)
When a user tries to type in a name or click the dropdown menu to search for a staff person, they run into one of these problems: either they are unable to type a name (they click the box for searching a name and can't type anything) or they click the dropdown arrow and instead of seeing a full list of staff names, they see one small empty box.
The reason this is happening is because when a user clicks on what should be cells B3 or C3, neither cell is actually selected. When the user uses an the arrows on their keyboard to get to the correct cell, they are then able to click into it and type in content, access the dropdown menu... But they can't just click onto the cells directly.
What can I do to fix this and enable people to directly edit these cells?
Bookmarks