Is there a VBA command or routine that “resets” all VBA processes?
As example (there may be others), what I’ve noticed is if an erroneous date is entered (say 01-33-24) an error will appear – “The value you entered is not valid”. I understand that. However, from that point I believe all other actions being controlled by either the Worksheet_Change or Worksheet_SelectionChange subroutines are halted. The only way I have been able to resolve this is by closing the file and reopening it. Any suggestions?
Thanks,
Steve
As example (there may be others), what I’ve noticed is if an erroneous date is entered (say 01-33-24) an error will appear – “The value you entered is not valid”. I understand that. However, from that point I believe all other actions being controlled by either the Worksheet_Change or Worksheet_SelectionChange subroutines are halted. The only way I have been able to resolve this is by closing the file and reopening it. Any suggestions?
Thanks,
Steve