XL2BB bug?

[GraH]

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.

 

[Fluff]

For the problem with the ribbon disappearing have a look here.

XL2BB Disappears when Excel is Reopened

If this happens to you, try one of these options: Option A: Close Excel Find the Add-In file in Windows File Explorer Right click - Properties On the 'General' tab, is there an 'Unblock' box at the bottom? If so, tick that box then click OK Reopen Excel Option B: An alternative to the above...

www.mrexcel.com

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

 

[GraH]

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]

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]

Glad that's solved it & thanks for the feedback.