Hi All,
I have a custom ribbon tab for a workbook that I would like to activate whenever the workbook is opened, so the user can get on with it straight away. Is there a way to achieve this?
Warm regards,
Jewel
Hi All,
I have a custom ribbon tab for a workbook that I would like to activate whenever the workbook is opened, so the user can get on with it straight away. Is there a way to achieve this?
Warm regards,
Jewel
Last edited by jewelsharma; 03-20-2014 at 09:12 PM.
is the custom tab deployed to all users that will open the file or you need to install it (through VBA) to all users that do not have it?
Click on the star if you think I helped you
You must use onload callback to hold Ribbon reference then you may use its ActivateTab method.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
The custom tab is deployed to all users that will open the file. The tab is named "Extras". All I want is that when the Workbook Opens, the "Extras" ribbon tab is activated instead of the "Home" tab.
Izandol, Kindly explain a little more about the "hold ribbon reference" part in your reply.
Thank you both.
Jewel
you need to put the control.ID (in the example 12345) of the custom ribbon tab.Please Login or Register to view this content.
CustomUI part must include
Workbook code must include callback:PHP Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="RibbonOnLoad"
then you may use myRib.ActivateTab "tabID"Please Login or Register to view this content.
There is example here: http://social.msdn.microsoft.com/For...0?forum=isvvba
Izandol, adyteo,
Thank you gurus.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks