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.
Activate custom ribbon tabs for differents sheets
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Activate custom ribbon tabs for differents sheets
Best Regards,
Adam
Adam
-
- 5StarLounger
- Posts: 964
- Joined: 08 Nov 2012, 17:54
Re: Activate custom ribbon tabs for differents sheets
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
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
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Re: Activate custom ribbon tabs for different sheets
Thankyou very much Lisa. Your links helped me alot.
Best Regards,
Adam
Adam
-
- 5StarLounger
- Posts: 964
- Joined: 08 Nov 2012, 17:54
Re: Activate custom ribbon tabs for differents sheets
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
Lisa
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: Activate custom ribbon tabs for differents sheets
I certainly will Lisa, thanks for the kind words :-)