Activate custom ribbon tabs for differents sheets

Hi and thanks in advance,

I am using Excel 2010 and have created a custom ribbon with two tabs and there are two worksheets. When you activate the Quote worksheet the tabQuote tab shows and the tabEstimate tab is hidden. When you activate the Estimate worksheet the tabEstimate tab shows and the tabQuote tab is hidden. The other Excel built in tabs are visible also. Both of my custom tabs are set to appear before the Home tab. When either of the custom tabs are shown I want them to be the active tab, which is not the case if one of the Excel built in tabs was the active tab prior to showing/hiding my tabs.

Hi there,

I'm aware of the following workaround for what you're trying to do, but I've never used it myself (so far anyway! )

Maybe the following link might be of some assistance:

http://www.vbaexpress.com/forum/arch...p/t-21022.html

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg,

Thanks for the link ... there was some interesting stuff on that post but in the end I found a fairly simple way to do what I wanted.

I put this code in a standard module:

Please Login or Register  to view this content.

And this code in the Worksheet_Activate events for the ribbon tab I want to activate for each sheet:

Please Login or Register  to view this content.

Please Login or Register  to view this content.