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!

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"XP" <(E-Mail Removed)> wrote in message news:66E2C265-FB5B-4239-87C0-(E-Mail Removed)...
> 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!

Oops

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "XP" <(E-Mail Removed)> wrote in message news:66E2C265-FB5B-4239-87C0-(E-Mail Removed)...
>> 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!

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

Thanks!

"Ron de Bruin" wrote:

> Oops
>
> In the open and close events and not the Activate and Deactivate events
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Ron de Bruin" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > 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
> >
> >
> >
> > --
> >
> > Regards Ron de Bruin
> > http://www.rondebruin.nl/tips.htm
> >
> >
> > "XP" <(E-Mail Removed)> wrote in message news:66E2C265-FB5B-4239-87C0-(E-Mail Removed)...
> >> 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!
>