Custom ribbon always jumps back to first tab

[harmankardon]

Hello all,

I've created a custom ribbon for my end users (Access 2010) and everything looks and works great except for one issue that is becoming a deal breaker for me and my end users:

I've got a number of tabs on my custom ribbon and on each tab there are a number of buttons that open various forms and reports. Anytime one of those forms or reports is opened and then closed, the ribbon jumps back to the first tab in my custom ribbon. So if you were on tab 3, opened a form and then closed it, you would be jumped back to tab 1.

Quite frustrating and annoying to say the least. Does anyone know a workaround for what seems to be "by design" behavior for custom ribbons? The built-in ribbon does not do this.....

 

[Ari]

Hi

See Question 7

http://www.ribbons-access.com/ms-access/ribbon-support-faq.asp#inicio

Add the onLoad attribute

<customUI xmlns = "http://schemas.microsoft.com/office/2009/07/customui" onLoad = "fncRibbon">

In the global module:

Option Compare Database
Public objRibbon As IRibbonUI

Public Sub fncRibbon(ribbon As IRibbonUI)
On Error Resume Next
Set objRibbon = ribbon
End Sub


Changing the focus:

objRibbon.ActivateTab "TabName"

 

[harmankardon]

This looks like a great ribbon resource, thanks!