As of now, I've already enabled my add-in in the Add-In dialog box and started to test in a new Excel Workbook file if it would work. Sadly, my add-in still halts at the statement above resulting to a "#VALUE!" result into the Cell.
In my uploaded image, you can see that there's 2 VBA projects. The one above is my add-in. Now I tried to add-watch "Application.Workbooks". Yes it did see a workbook, but it was VBAProject (Book1), not the workbook of my add-in. So how will I be able to access the Workbook (particularly the unviewable worksheets) of my add-in? TIA.
Btw, the worksheets enclosed inside the red box are the ones I want to access.