Activate custom ribbon tabs for differents sheets

User avatar
adam
SilverLounger
Posts: 2125
Joined: 23 Feb 2010, 12:07

Activate custom ribbon tabs for differents sheets

Post by adam »

Hi anyone,

Would be glad if anyone could let me know how to create a macro to open an excel ribbon tab when opening a sheet.

Let's say for example;
When I open sheet1 the macro would simultaneously open my custom tab "Menu" which contains the macro buttons for the sheet.

Any help on this would be kindly appreciated.
Best Regards,
Adam

LisaGreen
5StarLounger
Posts: 814
Joined: 08 Nov 2012, 17:54

Re: Activate custom ribbon tabs for differents sheets

Post by LisaGreen »

Hi Adam,

Check out Jan Karel Pieterse' site.

https://jkp-ads.com/Articles/buildexceladdin04.asp
and
https://jkp-ads.com/Articles/buildexceladdin05.asp

Are probably the pages you want. But!!!! It's an excellent site anyway from a very clever and talented and experienced MVP so do look around while you're there!

Let us know how you get on please.

HTH
Lisa

User avatar
adam
SilverLounger
Posts: 2125
Joined: 23 Feb 2010, 12:07

Re: Activate custom ribbon tabs for different sheets

Post by adam »

Thankyou very much Lisa. Your links helped me alot.
Best Regards,
Adam

LisaGreen
5StarLounger
Posts: 814
Joined: 08 Nov 2012, 17:54

Re: Activate custom ribbon tabs for differents sheets

Post by LisaGreen »

You are more than welcome Adam. Jan Karel is a great and really friendly.... If you any questions I'm sure he'll be glad to help!

Lisa

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 651
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: Activate custom ribbon tabs for differents sheets

Post by Jan Karel Pieterse »

I certainly will Lisa, thanks for the kind words :-)
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com