XL2BB Disappears when Excel is Reopened

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,634
Office Version
365
Platform
Windows
I'm not exactly sure where you are at now but if you carefully follow the steps listed here and at this step

1590827113248.png


XL2BB appears in the Add-Ins list for example like this

1590827199200.png


make sure that you carefully note the location (it will be different to what I have shown) then continue following the steps in the link above.

When you get to download the Add-In again, extract the xlam file and move it to somewhere you will know (Not a 'temp' folder I would suggest. Maybe even make your own Add-Ins folder, or use a location like the one shown above), unblock it if the properties show that is possible then proceed as per the instructions in the linked page.
 

Some videos you may like

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,160
Office Version
2016
Platform
Windows
Thanks. As I said in my post above I cannot delete as the X is unresponsive.
Though i tried to remove or change name that too was unsuccessful.
Can I use Extract all to delete and, if so , are there any things I should look out for
Thanks again
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,634
Office Version
365
Platform
Windows
Have you deselected XL2BB in this dialog?

1590828677234.png
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,160
Office Version
2016
Platform
Windows
Finally I think I have done it.
After rebooting (thanks) I downloaded from site and it took me to the 5/4/20 modification in Temp .
When I browsed I could not find it in the Temp file for some reason.
So I went to the Download arrow at top of screen and right clicked and it took me to the file at bottom of Temp (??) why i dont know.
So I copied file and pasted to desktop.
After browsing from Add in Screen and selecting desktop shortcut Mr Excel came up on excel sheet.
Whether it remains ??
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,160
Office Version
2016
Platform
Windows
Update.
When I closed down and reopened Mr Excel had disappeared again.
In frustration I right clicked on the desktop icon and selected Properties.
In the Attributes section at bottom I ticked Unblock and hey presto Mr Excel reappeared.
Closed Excel sheet again and reopened and all good.
Thanks Peter_ss for your help
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,634
Office Version
365
Platform
Windows
.. selected Properties.
In the Attributes section at bottom I ticked Unblock ...
I did mention that before ;)
.. download the Add-In again, extract the xlam file and move it to somewhere you will know ... unblock it if the properties show that is possible ....
.. and of course in the very first post in this thread
If this happens to you, try these steps:
  • Close Excel
  • Find the Add-In file in Windows File Explorer
  • Right click - Properties
  • On the 'General' tab, is there an 'Unblock' box at the bottom?
  • If so, tick that box then click OK
  • Reopen Excel
Anyway, let's hope it is all sorted now. (y)
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,160
Office Version
2016
Platform
Windows
It was what probably prompted my old mind.
Thanks again:mad:
 

Watch MrExcel Video

Forum statistics

Threads
1,099,036
Messages
5,466,150
Members
406,470
Latest member
Darshan Shah

This Week's Hot Topics

Top