Hello GlynB,
Failing that, could the date cell be formatted to only accept inputs from the existing code and nothing else?
It may be a better option so under your existing event code, place this one:-
A message box will appear as soon as a User clicks on a cell in Column M that has a date in it warning the User that no manual entries are allowed. Once OK is clicked, the cursor will return back to a cell in Column J.
It will allow manual entries if a cell is blank.
Just an option for you.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks