Custom tab available to all open workbooks?

[XP]

Using Windows XP with Office 2007;

I need a way to create a custom tab on the ribbon that will be visible and
usable to all open workbooks, until the file containing the code for the
custom tab is closed.

Is there a way to do this? If so, can I get some instructions on how to
accomplish this?

Thanks!

 

[Ron de Bruin]

Hi XP

You can create a add-in with your Ribbon.

And in the Activate and Deactivate event in the thisworkbook module
of your normal workbook open and close the add-in with code

 

[Ron de Bruin]

Oops

In the open and close events and not the Activate and Deactivate events

 

[XP]

Thanks Ron; I was thinking this might work; I will delve into this and see
what happens.

Thanks!