XL2BB Disappears when Excel is Reopened

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,161
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,165
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
45,161
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,165
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,165
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
45,161
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,165
Office Version
2016
Platform
Windows
It was what probably prompted my old mind.
Thanks again:mad:
 

Watch MrExcel Video

Forum statistics

Threads
1,102,182
Messages
5,485,235
Members
407,490
Latest member
leogaleleo84

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top