I'd like to be able to pin the ribbon tabs to stay on the current tab
when working on a task.

For example, if you are working on autoshapes with the formatting tab
open, then click a worksheet cell, it will revert back to the Home
tab. I'd like to be able to pin the formatting tab. A VBA solution is
preferred, but a manual solution would work as well.

Thanks,

Nick

Don't think this is possible, they are contextual, and MS insist that they
will control when they appear.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nick Hebb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'd like to be able to pin the ribbon tabs to stay on the current tab
> when working on a task.
>
> For example, if you are working on autoshapes with the formatting tab
> open, then click a worksheet cell, it will revert back to the Home
> tab. I'd like to be able to pin the formatting tab. A VBA solution is
> preferred, but a manual solution would work as well.
>
> Thanks,
>
> Nick
>

Thanks Bob.

That's kind of what I had expected. The IRibbonUI and related objects
seem extremely limited compared to the CommandBar counterparts, but I
was just hoping there was more to it than that.

- Nick

It is, but you might find this interesting
http://www.oaltd.co.uk/Spreads/Excel...ogRef_ch14.pdf

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nick Hebb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Thanks Bob.
>
> That's kind of what I had expected. The IRibbonUI and related objects
> seem extremely limited compared to the CommandBar counterparts, but I
> was just hoping there was more to it than that.
>
> - Nick
>