Before converting this workbook to an add-in, you need to test it. To simulate what happens when the workbook is an add-in, you should test the workbook when a different workbook is active. Remember, an add-in is never the active workbook, so testing it when another workbook is active will help you locate potential problems — such as incorrect references to ThisWorkbook.
Open a new workbook to try out the various features in the Text Tools utility. Do everything that you can think of to try to make it fail. Better yet, seek the assistance of someone unfamiliar with the application to give it a crash test.
Was this article helpful?