Results 1 to 2 of 2

Thread: RibbonX Custom Tab to show up upon opening

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Dec 2014
    Posts
    4
    Rep Power
    0

    RibbonX Custom Tab to show up upon opening

    I have created a ribbon from scratch and all is fine. Only two tabs and each called depending on a active worksheet. My only problem is ribbon does not show up when doc opens. No errors. I have to click on another sheet and ribbon loads. Is there any way I can correct this and have ribbon loaded immediately when doc openes? Below is code I have used to load the custom UI

    Code:
    Private Sub Workbook_SheetActivate(ByVal sh As Object)
        Select Case sh.CodeName
        Case "Sheet2": Call RefreshRibbon(Tag:="Cover")
        Case Else: Call RefreshRibbon(Tag:="Schedule")
        End Select
    
    End Sub
    Last edited by dkesar; 12-28-2014 at 03:40 AM.

Similar Threads

  1. Office RibbonX - Large SubMenu Items Within A Dynamic Menu
    By mahat in forum Excel Ribbon and Add-Ins
    Replies: 5
    Last Post: 12-19-2014, 09:21 AM
  2. Rename tab on cell value from another worksheet
    By jeremiah_j2k in forum Excel Help
    Replies: 6
    Last Post: 12-02-2014, 02:50 PM
  3. Worksheet Tab Name Based on Cell Value
    By tuna666 in forum Excel Help
    Replies: 2
    Last Post: 10-08-2013, 10:41 PM
  4. Opening URL @ new tab in Internet Explorer: VBA
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 09-11-2013, 08:22 PM
  5. How to Add Custom List And Use in Custom Sorting
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-07-2013, 10:41 PM

Posting Permissions

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