Results 1 to 10 of 17

Thread: Activate Ribbon Tab In Excel 2007 2010 *

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Rob, I tried in quite a few computers, and this is working without any error in all those computers.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  2. #2
    Junior Member
    Join Date
    Jan 2013
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Rob, I tried in quite a few computers, and this is working without any error in all those computers.
    I can confirm that this example file does not work with excel 2007.
    The sub "ActivateTab" is not able to set "PageTabListClient".

    Regards

  3. #3
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    15
    Thanks Admin, It really helps. Thanks a lot.

  4. #4
    Junior Member
    Join Date
    Dec 2013
    Posts
    6
    Rep Power
    0

    Activate Custom Tab

    Hi Admin, I am new to the forum and this is my first post. Please guide me if I am not going according to the forum rules.

    I have created a ribbon tab on my file and I want that tab (control id = "TabBT") to be selected once the file is opened. I would be using this file on Excel 2010 and Excel 2013. I tried several ways of doing it like, assigning a keytip and then using sendKeys (did not work). I also tried the solution given in this thread but no result.

    Would appreciate any help on this and would like to learn as how do we do it. Let me know if I was not very clear.

    Regards,
    Anish

  5. #5
    Junior Member
    Join Date
    Dec 2013
    Posts
    6
    Rep Power
    0
    Thank you very much.. I figured it out by looking at the very first file example you had attached. I am using Andy Pope's Ribbon Editor/Designer and it was not giving any call back option for CustomUI onLoad. I used the CustomUI editor and added that syntax. I worked fine after that.

    Regards,
    Anish

Similar Threads

  1. Test copy Activate Ribbon Tab In Excel 2007 2010 *
    By Excel Fox in forum Test Area
    Replies: 16
    Last Post: 01-22-2019, 05:05 PM
  2. Activate Ribbon Tab In Excel 2007 2010 *
    By Excel Fox in forum Test Area
    Replies: 16
    Last Post: 01-22-2019, 05:05 PM
  3. Replies: 1
    Last Post: 11-23-2013, 08:41 PM
  4. Ribbon DatePicker Calendar Control For Excel 2007-2010
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 5
    Last Post: 10-12-2013, 11:23 AM
  5. Ribbon Calendar DatePicker Word 2007-2010
    By Excel Fox in forum Download Center
    Replies: 24
    Last Post: 09-23-2013, 09:07 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •