I am using a Userform for data review and entry (row, by row) with the rows selectable by a dropdown menu in the userform.
The issue/problem:
When someone inputs something in the "Number" field ( which selects the row to be reviewed) that is not an actual existing number,.. (like say they accidentally backspace or hit "1" overwriting that number,) then their input overwrites the header of the column modified.
So I need to protect the headers at very least, and would like to actually be able to protect selected columns and even Cells or Rows ideally.
But when I do it using the built in "protection" cell formatting etc. Which I am able to do by intentionally "unprotecting" the cells I want to be modifiable and then protecting the wks, it "errors" announcing that a protected cell was attempted to be modified, and exits the userform.
I have protected portions of the userform from being modifiable, by attributing the "Locked" option in the userform design as "True" but cannot do that with a combobox with a selectable dropdown. Plus it would be nice to actually lock the wks even when the userform is not being used.
Im sure this question is not articulated as well as it could be.
Simply..
I need a way to protect certain cells on a .wks in such a way that it does not interfere in any way with the use of a userform for input.
Attatched is an old example of the userform and wks.
If you change the NUMBER value in the userform, and then hit enter and adjust any other value in the form and hit "Close" on the userform you should see that whatever you modified has been written to the header of the column of the category you modified.
Hence my delima.
Bookmarks