Can you pin ribbon tabs in Excel 2007?

[Nick Hebb]

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

 

[Bob Phillips]

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]

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

 

[Bob Phillips]

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

--
HTH

Bob

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