-
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 Facts
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
I think I stumbled onto the answer
www.mrexcel.com
XL2BB - Excel Range to BBCode
Just been trying XL2BB and works great. Drawback is I'm using European separators. Will they adapt ( to non European settings) when pasting to the board, and the other way round ? (I admit I did not read all the answers in this thread) I pasted from the board to my Excel version and had to do...
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,257
- Office Version
- 365
- Platform
- Windows
- Mobile
This is covered in the link in the instructions (under Preparing to Install the Add-In)
I have posted the link again below, you can also put the file in a Trusted Location
peltiertech.com
I have posted the link again below, you can also put the file in a Trusted Location
Install an Excel Add-In - Peltier Tech
A lot of Excel procedures are packaged in Add-Ins. An Add-In is basically a workbook containing some code, that has some other unique properties. An add-in usually has some user interface elements, such as buttons on the ribbon or on context (right-click) menus, so you can access its features...
I had read through that, but found a video and another explanation and between the three, figured it out. Also found I added to the wrong Add-in folder. So far no new error messages.This is covered in the link in the instructions (under Preparing to Install the Add-In)
View attachment 88731
I have posted the link again below, you can also put the file in a Trusted Location
Install an Excel Add-In - Peltier Tech
A lot of Excel procedures are packaged in Add-Ins. An Add-In is basically a workbook containing some code, that has some other unique properties. An add-in usually has some user interface elements, such as buttons on the ribbon or on context (right-click) menus, so you can access its features...
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,257
- Office Version
- 365
- Platform
- Windows
- Mobile
Happy you got it sorted (btw this will be the same with any file containing macro's that you download from the Internet or from an email as it is a Windows security setting rather than anything to do with XL2BB)
I figured as much, but in the past, I chose not to use the file. This one is unique. I am not sure for my current issue that it will help due to the conversion limitations, but we shall. I am trying to formulat a coherent question so I can post it.
Thanks again.
R.
ronny00789
New Member
- Joined
- Apr 30, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I am not able to paste the result from XL2BB. Is it a bug or I am doing it wrong ?
RICH937
Board Regular
- Joined
- Apr 15, 2023
- Messages
- 59
- Office Version
- 365
- Platform
- Windows
- Mobile
Can someone tell me what I'm doing wrong here? I managed to get the add-in loaded, and the stuff for the toolbar, but I cannot figure out how to capture the range. the "mini sheet" icon the instructions indicate I should click on remains grayed out no matter what I do. Suggestions?
Attachments
- Joined
- Feb 28, 2002
- Messages
- 2,571
Have you tried the following?
- Check the file properties and make sure you have selected the "Unblock" checkbox at the bottom of the General tab.
- 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)
- Try using the XLSTART folder, as explained in the add-in installation steps.
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 63,880
- Office Version
- 365
- Platform
- Windows
FYI: This is also covered in this Sticky at the top of the About This Board forum
