XL2BB - Excel Range to BBCode 2.1

[RICH937]

Have you tried the following?

1. Check the file properties and make sure you have selected the "Unblock" checkbox at the bottom of the General tab.
2. Save the xl2bb.xlam file to a trusted location, or add the folder that you saved the add-in as the trusted location in Excel (Note that I wouldn't add general folders like Downloads folder as a trusted location)
3. Try using the XLSTART folder, as explained in the add-in installation steps.

I tried all the other options, and none would work. the XLSTART option worked perfectly though. This would be my go to recommendation for everyone.

 

[smozgur]

I tried all the other options, and none would work. the XLSTART option worked perfectly though. This would be my go to recommendation for everyone.

It works because it is the folder that you confirm any file you put there is trusted. So it is definitely the file security issue but somehow the other options wouldn’t work in your case.

Glad to hear it works now

 

[PeteWright]

Hello everybody,

once every X times XL2BB doesn't copy anything (at least there's nothing in the clipboard that I could paste)
The addon (v2.0) is placed in a local folder (neither OneDrive, nor a system folder or network location), which is: C:\_OS\files\xl2bb.xlam
My Excel is M365 with latest updates on Win 10 Pro x64 with latest updates.

Please let me know if I need to provide any further information.

Kind regards
Pete

 

[ez08mba]

As I read earlier, Microsoft immediately blocked this Addin, but worst than that every single workbook opens with this message now regardless of how the Excel workbook was received.... meaning even if I create a workbook, I get this message. I also don't have the option to remove this Addin.

I could use some help fixing this please.

 

[ez08mba]

Ok, so once I deleted it from my desktop, all of this nonsense stopped and appears good. I guess I always thought these were copied to an Addins folder? But that was my solution.

 

[smozgur]

The add-in must be located in a trusted folder. Have you tried adding the add-in folder as the trusted location in Excel options?
File>Options>Trust Center>Trust Center Settings>Trusted Locations

Also, please right-click on the add-in file (xl2bb.xlam) and see the Properties/General/Security section at the bottom, and make sure that Unblock option is selected.

To remove the add-in, just delete the xlam file where you initially tried to install it, and come back to the same Add-ins dialog. Excel will complain about the add-in file cannot be find, and give you an option to remove it from the list. Confirm that option, and restart Excel.

 

[smozgur]

I guess I always thought these were copied to an Addins folder? But that was my solution.

It doesn't happen itself for any add-in, but instead, when you double click on an add-in file to install, Excel just uses the original location to install it. Since that location is not a trusted location, you experience that kind of non-sense issues. In that case, you need to make sure that Unblock option is selected as I explained in my earlier message.

Hope this helps.

 

[pawcoyote]

I have followed the instructions and installed the Add-in. It says it copied the info to the clipboard but when I go to paste in into my post nothing pastes. Not sure what I am doing wrong.

 

[MARK858]

You're probably not doing anything wrong, you are probably getting the issue in the link below

xl2BB

I am out of ideas. I will ask further afield.

www.mrexcel.com

The Admin think that they may have found a solution but it won't be available until the XL2BB 2.1 update comes out

How on earth can you post these XL2BB things?

(the attached file still exists) My apologies it does exist but is giving me this message I assume it is a new message either Bing or Windows is giving for xlsm's now :rolleyes:

www.mrexcel.com

 

[MARK858]

An image of the post in the last link as I think the link will be inactive soon as the post is in the Test forum.