I have a workbook which automatically populates cells C8 and C12 on the Entry Page sheet with values taken from the filename. It is supposed to prevent users from making changes to these two cells, and it works almost perfectly apart from when a user selects cell C8 and hits delete. My custom error message appears as it should, but then the cell is supposed to revert to it's previous value, and that's not happening.
I've been trying to figure out why exactly that is, since C12 has no issues undoing deletions. This is the section of the code in which the Undo is not functioning for C8 when the Delete key is used to clear it:
I've attached my sample workbook to hopefully help narrow this problem down. Thank you!Please Login or Register to view this content.
Bookmarks