0

I need to activate a specific Sheet if corresponding tab is activated
XML 

<tab id="books" label="books" onAction = "goTo1">

VBA 

Sub goTo1()
Sheet1.Activate
End Sub

It seems onAction attribute for tab element doesn't exist (noComment)
Is there another way to do this?

Alegro
  • 7,534
  • 17
  • 53
  • 74

1 Answers1

2

This would be using the Ribbon Interface "the other way round" - its not possible out of the box. The Idea of the ribbons is, that only actions and tabs are visible that make sense in the current sheet.

What you can do is have a timer on a hidden form that checks the active ribbon and activates the appropriate sheet. Getting the active tab is not trivial though - Look here for details.

Community
  • 1
  • 1