xl2bb

ozbeachbum

Board Regular
Joined
Jun 3, 2015
Messages
159
Office Version
  1. 2021
Platform
  1. Windows
Hi all,
I have just upgraded to Windows 11 and dowloaded xl2bb, however I get a warning message that Microsoft has disabled macros due to the certificate not being trusted.
Therefore xl2bb does not work.
Any advice to solve this issue would be greatly appreciated.
Cheers,
Dave.
 
Try...

Either put the file in a trusted location or right click the file, click properties, on the General tab near the bottom see if you have an unblock checkbox, if you do then click it.

1668473505711.png
 
Thanks Mark,
Checking the unblock box did the trick.
Dave.
 
You're welcome. Please note that this is covered in the XL2BB instructions if you click the link in the Note below in the actual instructions.
1668511603757.jpeg

 
Hi Mark,
I had the download and install instructions, I had copied them of the site previously, I missed the article from Jon Peltier.
Cheers,
Dave.
 
Thank you.
Apologies if I troubled you.
Dave.
 
Hi Mark,
As mentioned your advice to unblock the Add-in worked as the mini sheet button was no longer greyed out, however when I use it, the copy does not paste into the thread, and the clipboard is empty, even though a message saying Mini Sheet copied successfully appears.
I can't find reference to the issue any where.
Any suggestions.
Cheers,
Dave.
 
@smozgur didn't I see something about this issue somewhere? Any ideas?
 
@smozgur didn't I see something about this issue somewhere? Any ideas?
You are right, Mark. It has been discussed here:

And particularly in this post that I sent in the same thread:

@ozbeachbum: If you could take a look at the thread above then you'll see It is not an XL2BB-related problem directly as I was able to find that the same problem has been reported many times on the web. I believe it is something about Windows/Office shared clipboard, but not able to find a cure for that (and I doubt there is one), in fact, I can't even reproduce it on my computer(s).
 

Forum statistics

Threads
1,214,670
Messages
6,120,831
Members
448,990
Latest member
rohitsomani

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top