F FARAZ QURESHI Jun 4, 2009 #1 I have an AddIn installed and working. In mid of my work, if I need to close the file how can I do so? Thanx in advance.
I have an AddIn installed and working. In mid of my work, if I need to close the file how can I do so? Thanx in advance.
F FARAZ QURESHI Jun 4, 2009 #2 OK found it! Ctrl+G Jacob Skaria said: Un check from Tools>Add-In list (if you have browsed and installed your add-in) OR from immediate window Workbooks("addinname.xla").Close If this post helps click Yes Click to expand...
OK found it! Ctrl+G Jacob Skaria said: Un check from Tools>Add-In list (if you have browsed and installed your add-in) OR from immediate window Workbooks("addinname.xla").Close If this post helps click Yes Click to expand...
J Jon Peltier Jun 4, 2009 #3 Just so you know: Un check from Tools>Add-In list (if you have browsed and installed your add-in) Click to expand... Uninstalls the add-in. To use it again you need to recheck it. OR from immediate window Workbooks("addinname.xla").Close Click to expand... This closes the add-in for the current Excel session only, and it will again be available when Excel is restarted. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html _______
Just so you know: Un check from Tools>Add-In list (if you have browsed and installed your add-in) Click to expand... Uninstalls the add-in. To use it again you need to recheck it. OR from immediate window Workbooks("addinname.xla").Close Click to expand... This closes the add-in for the current Excel session only, and it will again be available when Excel is restarted. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html _______