tamaattorney.blogg.se - Task manager keeps closing

MsgBox "Your current setting has been saved" OBook.SaveAs ADDIN_PATH & "\" & "hello.xls" If (ComboBox2.Value = "") Then ComboBox2.Value = sCellName OSheet.Range("B2").Value = ComboBox1.Value 'oSheet.Range("B2").Value = ComboBox1.Value If (ComboBox1.Value = "-Select-" Or ComboBox1.Value = "") Then Set oBook = (ADDIN_PATH & "\" & "hello.xls") LastCol = Cells(1, unt).End(xlToLeft).Column Part of the code is as follows: Private Sub btn_Click()įinalrow = Cells(unt, 1).End(xlUp).row

But it is still running in the Task manager, which prevents my addin from working properly. Through excel VBA I'm opening a workbook and closing it, thus quitting the Excel application.