Hi All
I searched for something similar but I didn't find any. I have a situation here. See described below.
I have a code that update a template with a simple condition. If the condition is TRUE abort the UPDATE process.
If is FALSE continue running the code:
...
Sheet24.Activate
With ActiveSheet
LastCol = .Cells(2, .Columns.Count).End(xlToLeft).Column
If LastCol > 34 Then
MsgBox "myText" & Chr(10) & "Update Aborted!", vbCritical, "Number of weeks exceeded."
Exit Sub
End If
End With
...
When I find the condition TRUE, the code STOP, EXIT but my workbook stay frozen.
To use it again, need to close it and re-open it.
When the condition is FALSE, everything works fine.
Question:
How to make the code really STOP when the TRUE is found but allowing me to use the workbook without closing it.
I appreciate any help
Thanks and regards
A Mota
Bookmarks