XL2BB bug?

GraH

Active Member
Joined
Mar 22, 2020
Messages
485
Office Version
365, 2016
Platform
Windows
Hi,

Let me start by saying the XL2BB add-on is awesome. I can't imagine what the coding behind must be like. I'm in awe.

One thing starts to bugs me however. Each time I start up Excel the "Mr Excel" is gone from the ribbon, while the add-on is still "flagged" in the list as selected.
The workaround is removing the flag, confirming, reopening the add-ins list, resetting the flag "on" and it's back :). And this remains so until I close Excel.

Another pesky little thing: each time I use the "Capture Range" for the first time in a session, it copies nothing. So I click it once and generate a bogus output and the second or next times around it is working like a charm again.

Not sure if this is easily simulated and if other people report the same issues, but it might help to improve this fine piece of tooling. For info: I'm on a 64 bit installation of Office if that's important.
 

Some videos you may like

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,201
Office Version
365
Platform
Windows
For the problem with the ribbon disappearing have a look here.

I've never encountered the other problem your facing and haven't heard of anyone else with that problem, so can't help.
 

GraH

Active Member
Joined
Mar 22, 2020
Messages
485
Office Version
365, 2016
Platform
Windows
Thanks @Fluff I'll give that a go. Thought that was related to a previous version so have not tried it.
After a carefull reread I'm now thinking it's spot-on. Will reply if it worked.
 

GraH

Active Member
Joined
Mar 22, 2020
Messages
485
Office Version
365, 2016
Platform
Windows
Never noticed such a flag, but that was it! So sorry for the hassle. Should have read the darned manual.
Seems it solved the other issue too.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,201
Office Version
365
Platform
Windows
Glad that's solved it & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,038
Messages
5,472,116
Members
406,804
Latest member
xbinsx

This Week's Hot Topics

Top