Addin Issue Creating an N when opening a workbook on the Sheet

[mayoung]

I have been using an addin I created for some time. Recently I have noticed when I open an excel workbook and the addin opens it adds the letter N randomly onto the excel worksheet I have opened and its never to the same cell. If I uncheck the addin and close my workbook and reopen it this no longer happens. I thought maybe the addin workbook got corrupted so I open another workbook and moved all the modules over to it and resaved it as my addin. Then I moved my xml code using the ribbon editor. The letter N still appears randomly. Can anyone offer any suggestions??

 

[mayoung]

While doing some testing I found which ever cell I am in last when I reopen the workbook that's the cell the letter N appears in. But it only does this with the Addin turned on.

 

[Alex Blakenburg]

It sounds like you have access to the Add-In code.
Do a search on the whole project "Current Project" for Sub App_WorkbookOpen
If you find it is there a line using ActiveCell in there ?

 

[mayoung]

It sounds like you have access to the Add-In code.
Do a search on the whole project "Current Project" for Sub App_WorkbookOpen
If you find it is there a line using ActiveCell in there ?

 

[mayoung]

I searched my code and as suggested and found nothing.

 

[Alex Blakenburg]

You could try just searching for Activecell but if that is used frequently then that might get impractical.
I that doesn't work maybe share the Add-In on Google drive or drop box etc and we can have a look.

 

[mayoung]

You could try just searching for Activecell but if that is used frequently then that might get impractical.
I that doesn't work maybe share the Add-In on Google drive or drop box etc and we can have a look.

Let me know how to share it and I can do that. I have both Google drive and drop box

 

[Alex Blakenburg]

On either share the file to anyone with the link and post the link here.

 

[mayoung]

On either share the file to anyone with the link and post the link here.

I am going warn you I am self taught so much of my code may be crude and how it’s set up. But it works for me. Link to Addin

 

[Alex Blakenburg]

Do you want to load a copy without the password or send the password ?