• If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
  • Excel articles and downloadable files provided in the articles have not been reviewed by MrExcel Publishing. Please apply the provided methods / codes and open the files at your own risk. If you have any questions regarding an article, please use the Article Discussion section.
smozgur

XL2BB - Excel Range to BBCode 2.1

No permission to download

Reviews 4.14 star(s) 14 reviews

I cannot install the macro as it says it is blocked for security reason. I read the Peltier article and it showed going to the properties of the xlam file and unblocking. However, when i rt. click the file and go to properties, my properties dialog does not look at all like the one shown. It has only one tab, "General" (not Security, Details, and Previous versions). And the "General tab" does not have the verbiage to unblock as shown in the article. Any suggestions as to how to unblock and install?
I have it installed but it does not show when I open up Excel and when I try to add it as an Add On nothing happens...have I missed a trick?
smozgur
smozgur
After unzipping the xl2bb.xlam file, right click on it and Properties->General->Security section at the bottom, and uncheck the Unblock checkbox if it is checked already. Then follow the instructions in the Overview page at the top of this page. If it still doesn't work in your computer, then try the alternative installation with XLSTART folder (which actually works 100%).

Also, this is the Review area that is supposed to contain reviews, so I suggest asking for help in the Discussion section instead. In fact, there are many other questions and solutions like yours over there.
Unfortunately it doesn't seem to be working with Excel for MAC. I get the following error:

Run-time error '1004': Method 'Type' of object 'Validation' failed.

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