Custom tab available to all open workbooks?

X

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!
 
R

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
 
X

XP

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

Thanks!
 
Top