Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

Hello there

I try to unload my Addin, but i got this msg:

Thisworkbook is currently referenced by other workbook and can not be closed

Each time when i want to remove it from the main menue, I have to go to toolbars > customize and remove it.

before it used to be unloaded normally by unchecked the addin from the addin window.

could you tell how to solve this problem ?

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

Thanks, Dave

OK

simply, the Addin has a command to insert a sheet in the opened workbook. This is to make some calculations and review some technical points. Then I delete the inserted sheet.

insert and delete sheet works fine. only when unloading the addin the msg appear.

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

I checked and it is not linked to another filea nor any file linked to the add-in

!!! i am surprice, it used to work fine

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

Thank you for reply

I tried searching the MS, but ...................:sailboat:

I, surprisingly, note that when I open the Excel App the Add-in is loaded despit the fact that it is not checked in the Add-in window nor even listed inside the add-in window.

I.E. the add-in is not listed at all in the Add-in window and still loaded when the Excel App is opened. And the Add-in is not in the XLStart folder.

When open Excel App before it used to be open normally.
I think the problem that creat the msg is this

So, how can I make the Excel App open without my Add-in bing loaded ?[hr]*[/hr] Auto[hr]*[/hr] [b]Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Ok, I solve the problem
My mistake was about saving the Add-in
I deleted all copies of my add-in and took my back up copy and save a copy of it in add-in folder. Then againg took a copy of it and save it in my folder.

now Excel opens normally without hte add-in bing loaded.
load and unload my add-in works fine.

however, after this the problem appears again ?????

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

OK

by now I solved the problem.

I reregister the Excel, named the Excel to Excel.old and deleted all the registered Add-ins

Then my add-in worked well