Link to home
Create AccountLog in
Microsoft Excel

Microsoft Excel

--

Questions

--

Followers

Top Experts

Avatar of Murray Brown
Murray Brown🇬🇧

Excel VB.net VSTO Add-in Ribbon buttons not showing
Hi

I created a new Excel VSTO Add-in in Visual Studio 2019 and imported the files from an Excel VSTO Add-in that I created in Visual Studio 2017. This included a ribbon. My problem is that the Ribbon tab has disappeared and I cannot see any buttons. The first image shows how the ribbon looks in design view and the second image shows what the ribbon looks in Excel in debug mode.

User generated image

User generated image

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


ASKER CERTIFIED SOLUTION
Avatar of Serge FournierSerge Fournier🇨🇦

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of Murray BrownMurray Brown🇬🇧

ASKER

I think I have a VB ribbon that doesn't have XML. The Designer looks as follows

Partial Class Ribbon1
    Inherits Microsoft.Office.Tools.Ribbon.RibbonBase

    <System.Diagnostics.DebuggerNonUserCode()> _
   Public Sub New(ByVal container As System.ComponentModel.IContainer)
        MyClass.New()

        'Required for Windows.Forms Class Composition Designer support
        If (container IsNot Nothing) Then
            container.Add(Me)
        End If

    End Sub

    <System.Diagnostics.DebuggerNonUserCode()> _
    Public Sub New()
        MyBase.New(Globals.Factory.GetRibbonFactory())

        'This call is required by the Component Designer.
        InitializeComponent()

    End Sub

    'Component overrides dispose to clean up the component list.
    <System.Diagnostics.DebuggerNonUserCode()> _
    Protected Overrides Sub Dispose(ByVal disposing As Boolean)
        Try
            If disposing AndAlso components IsNot Nothing Then
                components.Dispose()
            End If
        Finally
            MyBase.Dispose(disposing)
        End Try
    End Sub

    'Required by the Component Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Component Designer
    'It can be modified using the Component Designer.
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> _
    Private Sub InitializeComponent()
        Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(Ribbon1))
        Me.Tab1 = Me.Factory.CreateRibbonTab
        Me.GroupConnect = Me.Factory.CreateRibbonGroup
        Me.ComboBox_Connection = Me.Factory.CreateRibbonComboBox
        Me.btnManageConnections = Me.Factory.CreateRibbonButton
        Me.Menu1 = Me.Factory.CreateRibbonMenu
        Me.btnUsers = Me.Factory.CreateRibbonButton
        Me.chkPaneMode = Me.Factory.CreateRibbonCheckBox
        Me.chkUseAppSettings = Me.Factory.CreateRibbonCheckBox
        Me.GroupConnectToCloud = Me.Factory.CreateRibbonGroup
        Me.ButtonLogin = Me.Factory.CreateRibbonButton
        Me.GroupDateControl = Me.Factory.CreateRibbonGroup
        Me.btnSelectDates = Me.Factory.CreateRibbonButton
        Me.lblFromDate = Me.Factory.CreateRibbonLabel
        Me.lblToDate = Me.Factory.CreateRibbonLabel
        Me.ToggleButton_DateControl = Me.Factory.CreateRibbonToggleButton
        Me.GroupSQL = Me.Factory.CreateRibbonGroup
        Me.ToggleButton_CustomSQL = Me.Factory.CreateRibbonToggleButton
        Me.btnRunCellQueriesCurrentSheet = Me.Factory.CreateRibbonButton
        Me.btnRunCellQueriesAllSheets = Me.Factory.CreateRibbonButton
        Me.GroupGetData = Me.Factory.CreateRibbonGroup
        Me.ToggleButton_Tables = Me.Factory.CreateRibbonToggleButton
        Me.btnSingleValue = Me.Factory.CreateRibbonButton
        Me.btnMultipleValues = Me.Factory.CreateRibbonButton
        Me.btnTablesOther = Me.Factory.CreateRibbonButton
        Me.ToggleButton_LoadToExcel = Me.Factory.CreateRibbonToggleButton
        Me.ToggleButton_Mirror = Me.Factory.CreateRibbonToggleButton
        Me.GroupLoadData = Me.Factory.CreateRibbonGroup
        Me.ComboBox_Queries = Me.Factory.CreateRibbonComboBox
        Me.ComboBox_Tables = Me.Factory.CreateRibbonComboBox
        Me.ComboBox_IdentityColumn = Me.Factory.CreateRibbonComboBox
        Me.btnLoadToForm = Me.Factory.CreateRibbonButton
        Me.btnLoadToExcel = Me.Factory.CreateRibbonButton
        Me.Group1 = Me.Factory.CreateRibbonGroup
        Me.btnUpdateUsingCellSelection = Me.Factory.CreateRibbonButton
        Me.btnAddRowsInCellSelection = Me.Factory.CreateRibbonButton
        Me.btnDeleteRowsInCellSelection = Me.Factory.CreateRibbonButton
        Me.GroupLogin = Me.Factory.CreateRibbonGroup
        Me.Box1 = Me.Factory.CreateRibbonBox
        Me.EditBoxUsername = Me.Factory.CreateRibbonEditBox
        Me.EditBoxPassword = Me.Factory.CreateRibbonEditBox
        Me.btnLogin = Me.Factory.CreateRibbonButton
        Me.GroupOther = Me.Factory.CreateRibbonGroup
        Me.lblVersion = Me.Factory.CreateRibbonLabel
        Me.btnTest = Me.Factory.CreateRibbonButton
        Me.lblOnOff = Me.Factory.CreateRibbonLabel
        Me.GroupLogout = Me.Factory.CreateRibbonGroup
        Me.btnLogout = Me.Factory.CreateRibbonButton
        Me.Group2 = Me.Factory.CreateRibbonGroup
        Me.btnMyStock = Me.Factory.CreateRibbonButton
        Me.btnWanted = Me.Factory.CreateRibbonButton
        Me.Tab1.SuspendLayout()
        Me.GroupConnect.SuspendLayout()
        Me.GroupConnectToCloud.SuspendLayout()
        Me.GroupDateControl.SuspendLayout()
        Me.GroupSQL.SuspendLayout()
        Me.GroupGetData.SuspendLayout()
        Me.GroupLoadData.SuspendLayout()
        Me.Group1.SuspendLayout()
        Me.GroupLogin.SuspendLayout()
        Me.Box1.SuspendLayout()
        Me.GroupOther.SuspendLayout()
        Me.GroupLogout.SuspendLayout()
        Me.Group2.SuspendLayout()
        Me.SuspendLayout()
        '
        'Tab1
        '
        Me.Tab1.Groups.Add(Me.GroupConnect)
        Me.Tab1.Groups.Add(Me.GroupConnectToCloud)
        Me.Tab1.Groups.Add(Me.GroupDateControl)
        Me.Tab1.Groups.Add(Me.GroupSQL)
        Me.Tab1.Groups.Add(Me.GroupGetData)
        Me.Tab1.Groups.Add(Me.GroupLoadData)
        Me.Tab1.Groups.Add(Me.Group2)
        Me.Tab1.Groups.Add(Me.Group1)
        Me.Tab1.Groups.Add(Me.GroupLogin)
        Me.Tab1.Groups.Add(Me.GroupOther)
        Me.Tab1.Groups.Add(Me.GroupLogout)
        Me.Tab1.Label = "The Steel Yard"
        Me.Tab1.Name = "Tab1"
        '
        'GroupConnect
        '
        Me.GroupConnect.Items.Add(Me.ComboBox_Connection)
        Me.GroupConnect.Items.Add(Me.btnManageConnections)
        Me.GroupConnect.Items.Add(Me.Menu1)
        Me.GroupConnect.Label = "Connect"
        Me.GroupConnect.Name = "GroupConnect"
        '
        'ComboBox_Connection
        '
        Me.ComboBox_Connection.Label = "Connect"
        Me.ComboBox_Connection.Name = "ComboBox_Connection"
        Me.ComboBox_Connection.Text = Nothing
        '
        'btnManageConnections
        '
        Me.btnManageConnections.Label = "Manage Connections"
        Me.btnManageConnections.Name = "btnManageConnections"
        '
        'Menu1
        '
        Me.Menu1.Items.Add(Me.btnUsers)
        Me.Menu1.Items.Add(Me.chkPaneMode)
        Me.Menu1.Items.Add(Me.chkUseAppSettings)
        Me.Menu1.Label = "Settings/Users"
        Me.Menu1.Name = "Menu1"
        '
        'btnUsers
        '
        Me.btnUsers.Image = CType(resources.GetObject("btnUsers.Image"), System.Drawing.Image)
        Me.btnUsers.Label = "Users"
        Me.btnUsers.Name = "btnUsers"
        Me.btnUsers.ShowImage = True
        '
        'chkPaneMode
        '
        Me.chkPaneMode.Checked = True
        Me.chkPaneMode.Label = "Pane Mode"
        Me.chkPaneMode.Name = "chkPaneMode"
        '
        'chkUseAppSettings
        '
        Me.chkUseAppSettings.Label = "Use App Settings"
        Me.chkUseAppSettings.Name = "chkUseAppSettings"
        '
        'GroupConnectToCloud
        '
        Me.GroupConnectToCloud.Items.Add(Me.ButtonLogin)
        Me.GroupConnectToCloud.Label = "Activate"
        Me.GroupConnectToCloud.Name = "GroupConnectToCloud"
        '
        'ButtonLogin
        '
        Me.ButtonLogin.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.ButtonLogin.Image = CType(resources.GetObject("ButtonLogin.Image"), System.Drawing.Image)
        Me.ButtonLogin.Label = "Activate"
        Me.ButtonLogin.Name = "ButtonLogin"
        Me.ButtonLogin.ShowImage = True
        '
        'GroupDateControl
        '
        Me.GroupDateControl.Items.Add(Me.btnSelectDates)
        Me.GroupDateControl.Items.Add(Me.lblFromDate)
        Me.GroupDateControl.Items.Add(Me.lblToDate)
        Me.GroupDateControl.Items.Add(Me.ToggleButton_DateControl)
        Me.GroupDateControl.Label = "Date Control"
        Me.GroupDateControl.Name = "GroupDateControl"
        Me.GroupDateControl.Visible = False
        '
        'btnSelectDates
        '
        Me.btnSelectDates.Image = CType(resources.GetObject("btnSelectDates.Image"), System.Drawing.Image)
        Me.btnSelectDates.Label = "Select Dates"
        Me.btnSelectDates.Name = "btnSelectDates"
        Me.btnSelectDates.ShowImage = True
        '
        'lblFromDate
        '
        Me.lblFromDate.Label = "-"
        Me.lblFromDate.Name = "lblFromDate"
        '
        'lblToDate
        '
        Me.lblToDate.Label = "-"
        Me.lblToDate.Name = "lblToDate"
        '
        'ToggleButton_DateControl
        '
        Me.ToggleButton_DateControl.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.ToggleButton_DateControl.Image = CType(resources.GetObject("ToggleButton_DateControl.Image"), System.Drawing.Image)
        Me.ToggleButton_DateControl.Label = "Use Date Control"
        Me.ToggleButton_DateControl.Name = "ToggleButton_DateControl"
        Me.ToggleButton_DateControl.ShowImage = True
        '
        'GroupSQL
        '
        Me.GroupSQL.Items.Add(Me.ToggleButton_CustomSQL)
        Me.GroupSQL.Items.Add(Me.btnRunCellQueriesCurrentSheet)
        Me.GroupSQL.Items.Add(Me.btnRunCellQueriesAllSheets)
        Me.GroupSQL.Label = "SQL"
        Me.GroupSQL.Name = "GroupSQL"
        Me.GroupSQL.Visible = False
        '
        'ToggleButton_CustomSQL
        '
        Me.ToggleButton_CustomSQL.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.ToggleButton_CustomSQL.Image = CType(resources.GetObject("ToggleButton_CustomSQL.Image"), System.Drawing.Image)
        Me.ToggleButton_CustomSQL.Label = "SQL Builder"
        Me.ToggleButton_CustomSQL.Name = "ToggleButton_CustomSQL"
        Me.ToggleButton_CustomSQL.ShowImage = True
        '
        'btnRunCellQueriesCurrentSheet
        '
        Me.btnRunCellQueriesCurrentSheet.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnRunCellQueriesCurrentSheet.Image = CType(resources.GetObject("btnRunCellQueriesCurrentSheet.Image"), System.Drawing.Image)
        Me.btnRunCellQueriesCurrentSheet.Label = "Run Comments   This Sheet"
        Me.btnRunCellQueriesCurrentSheet.Name = "btnRunCellQueriesCurrentSheet"
        Me.btnRunCellQueriesCurrentSheet.ShowImage = True
        '
        'btnRunCellQueriesAllSheets
        '
        Me.btnRunCellQueriesAllSheets.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnRunCellQueriesAllSheets.Image = CType(resources.GetObject("btnRunCellQueriesAllSheets.Image"), System.Drawing.Image)
        Me.btnRunCellQueriesAllSheets.Label = "Run Comments   All Sheets"
        Me.btnRunCellQueriesAllSheets.Name = "btnRunCellQueriesAllSheets"
        Me.btnRunCellQueriesAllSheets.ShowImage = True
        '
        'GroupGetData
        '
        Me.GroupGetData.Items.Add(Me.ToggleButton_Tables)
        Me.GroupGetData.Items.Add(Me.btnSingleValue)
        Me.GroupGetData.Items.Add(Me.btnMultipleValues)
        Me.GroupGetData.Items.Add(Me.btnTablesOther)
        Me.GroupGetData.Items.Add(Me.ToggleButton_LoadToExcel)
        Me.GroupGetData.Items.Add(Me.ToggleButton_Mirror)
        Me.GroupGetData.Label = "Get Data"
        Me.GroupGetData.Name = "GroupGetData"
        Me.GroupGetData.Visible = False
        '
        'ToggleButton_Tables
        '
        Me.ToggleButton_Tables.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.ToggleButton_Tables.Image = CType(resources.GetObject("ToggleButton_Tables.Image"), System.Drawing.Image)
        Me.ToggleButton_Tables.Label = "Tables"
        Me.ToggleButton_Tables.Name = "ToggleButton_Tables"
        Me.ToggleButton_Tables.ShowImage = True
        '
        'btnSingleValue
        '
        Me.btnSingleValue.Label = "Single Value"
        Me.btnSingleValue.Name = "btnSingleValue"
        Me.btnSingleValue.Visible = False
        '
        'btnMultipleValues
        '
        Me.btnMultipleValues.Label = "Multiple Values"
        Me.btnMultipleValues.Name = "btnMultipleValues"
        Me.btnMultipleValues.Visible = False
        '
        'btnTablesOther
        '
        Me.btnTablesOther.Label = "Tables/Other"
        Me.btnTablesOther.Name = "btnTablesOther"
        Me.btnTablesOther.Visible = False
        '
        'ToggleButton_LoadToExcel
        '
        Me.ToggleButton_LoadToExcel.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.ToggleButton_LoadToExcel.Image = CType(resources.GetObject("ToggleButton_LoadToExcel.Image"), System.Drawing.Image)
        Me.ToggleButton_LoadToExcel.Label = "Load to Excel"
        Me.ToggleButton_LoadToExcel.Name = "ToggleButton_LoadToExcel"
        Me.ToggleButton_LoadToExcel.ShowImage = True
        Me.ToggleButton_LoadToExcel.Visible = False
        '
        'ToggleButton_Mirror
        '
        Me.ToggleButton_Mirror.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.ToggleButton_Mirror.Image = CType(resources.GetObject("ToggleButton_Mirror.Image"), System.Drawing.Image)
        Me.ToggleButton_Mirror.Label = "Mirror"
        Me.ToggleButton_Mirror.Name = "ToggleButton_Mirror"
        Me.ToggleButton_Mirror.ShowImage = True
        '
        'GroupLoadData
        '
        Me.GroupLoadData.Items.Add(Me.ComboBox_Queries)
        Me.GroupLoadData.Items.Add(Me.ComboBox_Tables)
        Me.GroupLoadData.Items.Add(Me.ComboBox_IdentityColumn)
        Me.GroupLoadData.Items.Add(Me.btnLoadToForm)
        Me.GroupLoadData.Items.Add(Me.btnLoadToExcel)
        Me.GroupLoadData.Label = "Load Data"
        Me.GroupLoadData.Name = "GroupLoadData"
        '
        'ComboBox_Queries
        '
        Me.ComboBox_Queries.Label = "Queries"
        Me.ComboBox_Queries.Name = "ComboBox_Queries"
        Me.ComboBox_Queries.Text = Nothing
        '
        'ComboBox_Tables
        '
        Me.ComboBox_Tables.Label = "Tables"
        Me.ComboBox_Tables.Name = "ComboBox_Tables"
        Me.ComboBox_Tables.Text = Nothing
        '
        'ComboBox_IdentityColumn
        '
        Me.ComboBox_IdentityColumn.Label = "ID Column"
        Me.ComboBox_IdentityColumn.Name = "ComboBox_IdentityColumn"
        Me.ComboBox_IdentityColumn.Text = Nothing
        '
        'btnLoadToForm
        '
        Me.btnLoadToForm.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnLoadToForm.Image = CType(resources.GetObject("btnLoadToForm.Image"), System.Drawing.Image)
        Me.btnLoadToForm.Label = "Load To Form"
        Me.btnLoadToForm.Name = "btnLoadToForm"
        Me.btnLoadToForm.ShowImage = True
        '
        'btnLoadToExcel
        '
        Me.btnLoadToExcel.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnLoadToExcel.Image = CType(resources.GetObject("btnLoadToExcel.Image"), System.Drawing.Image)
        Me.btnLoadToExcel.Label = "Load To   Excel"
        Me.btnLoadToExcel.Name = "btnLoadToExcel"
        Me.btnLoadToExcel.ShowImage = True
        '
        'Group1
        '
        Me.Group1.Items.Add(Me.btnUpdateUsingCellSelection)
        Me.Group1.Items.Add(Me.btnAddRowsInCellSelection)
        Me.Group1.Items.Add(Me.btnDeleteRowsInCellSelection)
        Me.Group1.Label = "Edit/Add/Delete Data"
        Me.Group1.Name = "Group1"
        '
        'btnUpdateUsingCellSelection
        '
        Me.btnUpdateUsingCellSelection.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnUpdateUsingCellSelection.Image = CType(resources.GetObject("btnUpdateUsingCellSelection.Image"), System.Drawing.Image)
        Me.btnUpdateUsingCellSelection.Label = "Update Using Cell Selection"
        Me.btnUpdateUsingCellSelection.Name = "btnUpdateUsingCellSelection"
        Me.btnUpdateUsingCellSelection.ShowImage = True
        '
        'btnAddRowsInCellSelection
        '
        Me.btnAddRowsInCellSelection.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnAddRowsInCellSelection.Image = CType(resources.GetObject("btnAddRowsInCellSelection.Image"), System.Drawing.Image)
        Me.btnAddRowsInCellSelection.Label = "Add Rows In Cell Selection"
        Me.btnAddRowsInCellSelection.Name = "btnAddRowsInCellSelection"
        Me.btnAddRowsInCellSelection.ShowImage = True
        '
        'btnDeleteRowsInCellSelection
        '
        Me.btnDeleteRowsInCellSelection.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnDeleteRowsInCellSelection.Image = CType(resources.GetObject("btnDeleteRowsInCellSelection.Image"), System.Drawing.Image)
        Me.btnDeleteRowsInCellSelection.Label = "Delete Rows In Cell Selection"
        Me.btnDeleteRowsInCellSelection.Name = "btnDeleteRowsInCellSelection"
        Me.btnDeleteRowsInCellSelection.ShowImage = True
        '
        'GroupLogin
        '
        Me.GroupLogin.Items.Add(Me.Box1)
        Me.GroupLogin.Label = "Log In"
        Me.GroupLogin.Name = "GroupLogin"
        '
        'Box1
        '
        Me.Box1.BoxStyle = Microsoft.Office.Tools.Ribbon.RibbonBoxStyle.Vertical
        Me.Box1.Items.Add(Me.EditBoxUsername)
        Me.Box1.Items.Add(Me.EditBoxPassword)
        Me.Box1.Items.Add(Me.btnLogin)
        Me.Box1.Name = "Box1"
        '
        'EditBoxUsername
        '
        Me.EditBoxUsername.Label = "Username"
        Me.EditBoxUsername.Name = "EditBoxUsername"
        Me.EditBoxUsername.Text = Nothing
        '
        'EditBoxPassword
        '
        Me.EditBoxPassword.Label = "Password"
        Me.EditBoxPassword.Name = "EditBoxPassword"
        Me.EditBoxPassword.Text = Nothing
        '
        'btnLogin
        '
        Me.btnLogin.Label = "Log In"
        Me.btnLogin.Name = "btnLogin"
        '
        'GroupOther
        '
        Me.GroupOther.Items.Add(Me.lblVersion)
        Me.GroupOther.Items.Add(Me.btnTest)
        Me.GroupOther.Items.Add(Me.lblOnOff)
        Me.GroupOther.Label = "Other"
        Me.GroupOther.Name = "GroupOther"
        Me.GroupOther.Visible = False
        '
        'lblVersion
        '
        Me.lblVersion.Label = "-"
        Me.lblVersion.Name = "lblVersion"
        '
        'btnTest
        '
        Me.btnTest.Label = "Test"
        Me.btnTest.Name = "btnTest"
        '
        'lblOnOff
        '
        Me.lblOnOff.Label = "Off"
        Me.lblOnOff.Name = "lblOnOff"
        '
        'GroupLogout
        '
        Me.GroupLogout.Items.Add(Me.btnLogout)
        Me.GroupLogout.Label = "Log Out"
        Me.GroupLogout.Name = "GroupLogout"
        '
        'btnLogout
        '
        Me.btnLogout.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnLogout.Image = CType(resources.GetObject("btnLogout.Image"), System.Drawing.Image)
        Me.btnLogout.Label = "Log Out"
        Me.btnLogout.Name = "btnLogout"
        Me.btnLogout.ShowImage = True
        '
        'Group2
        '
        Me.Group2.Items.Add(Me.btnMyStock)
        Me.Group2.Items.Add(Me.btnWanted)
        Me.Group2.Label = "Load My Data"
        Me.Group2.Name = "Group2"
        '
        'btnMyStock
        '
        Me.btnMyStock.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnMyStock.Image = CType(resources.GetObject("btnMyStock.Image"), System.Drawing.Image)
        Me.btnMyStock.Label = "My Stock Items"
        Me.btnMyStock.Name = "btnMyStock"
        Me.btnMyStock.ShowImage = True
        '
        'btnWanted
        '
        Me.btnWanted.ControlSize = Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge
        Me.btnWanted.Image = CType(resources.GetObject("btnWanted.Image"), System.Drawing.Image)
        Me.btnWanted.Label = "My Wanted Items"
        Me.btnWanted.Name = "btnWanted"
        Me.btnWanted.ShowImage = True
        '
        'Ribbon1
        '
        Me.Name = "Ribbon1"
        Me.RibbonType = "Microsoft.Excel.Workbook"
        Me.Tabs.Add(Me.Tab1)
        Me.Tab1.ResumeLayout(False)
        Me.Tab1.PerformLayout()
        Me.GroupConnect.ResumeLayout(False)
        Me.GroupConnect.PerformLayout()
        Me.GroupConnectToCloud.ResumeLayout(False)
        Me.GroupConnectToCloud.PerformLayout()
        Me.GroupDateControl.ResumeLayout(False)
        Me.GroupDateControl.PerformLayout()
        Me.GroupSQL.ResumeLayout(False)
        Me.GroupSQL.PerformLayout()
        Me.GroupGetData.ResumeLayout(False)
        Me.GroupGetData.PerformLayout()
        Me.GroupLoadData.ResumeLayout(False)
        Me.GroupLoadData.PerformLayout()
        Me.Group1.ResumeLayout(False)
        Me.Group1.PerformLayout()
        Me.GroupLogin.ResumeLayout(False)
        Me.GroupLogin.PerformLayout()
        Me.Box1.ResumeLayout(False)
        Me.Box1.PerformLayout()
        Me.GroupOther.ResumeLayout(False)
        Me.GroupOther.PerformLayout()
        Me.GroupLogout.ResumeLayout(False)
        Me.GroupLogout.PerformLayout()
        Me.Group2.ResumeLayout(False)
        Me.Group2.PerformLayout()
        Me.ResumeLayout(False)

    End Sub

    Friend WithEvents Tab1 As Microsoft.Office.Tools.Ribbon.RibbonTab
    Friend WithEvents GroupLoadData As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents btnUpdateUsingCellSelection As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents ComboBox_Tables As Microsoft.Office.Tools.Ribbon.RibbonComboBox
    Friend WithEvents btnAddRowsInCellSelection As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnDeleteRowsInCellSelection As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents GroupConnect As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents ComboBox_Connection As Microsoft.Office.Tools.Ribbon.RibbonComboBox
    Friend WithEvents btnManageConnections As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents ComboBox_IdentityColumn As Microsoft.Office.Tools.Ribbon.RibbonComboBox
    Friend WithEvents GroupDateControl As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents btnSelectDates As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents lblFromDate As Microsoft.Office.Tools.Ribbon.RibbonLabel
    Friend WithEvents lblToDate As Microsoft.Office.Tools.Ribbon.RibbonLabel
    Friend WithEvents ToggleButton_DateControl As Microsoft.Office.Tools.Ribbon.RibbonToggleButton
    Friend WithEvents GroupGetData As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents ToggleButton_LoadToExcel As Microsoft.Office.Tools.Ribbon.RibbonToggleButton
    Friend WithEvents btnSingleValue As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnMultipleValues As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnRunCellQueriesCurrentSheet As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnRunCellQueriesAllSheets As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnTablesOther As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnLoadToExcel As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnLoadToForm As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents ComboBox_Queries As Microsoft.Office.Tools.Ribbon.RibbonComboBox
    Friend WithEvents GroupConnectToCloud As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents Group1 As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents ToggleButton_Tables As Microsoft.Office.Tools.Ribbon.RibbonToggleButton
    Friend WithEvents GroupOther As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents lblVersion As Microsoft.Office.Tools.Ribbon.RibbonLabel
    Friend WithEvents btnTest As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents ToggleButton_Mirror As Microsoft.Office.Tools.Ribbon.RibbonToggleButton
    Friend WithEvents ToggleButton_CustomSQL As Microsoft.Office.Tools.Ribbon.RibbonToggleButton
    Friend WithEvents chkPaneMode As Microsoft.Office.Tools.Ribbon.RibbonCheckBox
    Friend WithEvents GroupLogin As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents Box1 As Microsoft.Office.Tools.Ribbon.RibbonBox
    Friend WithEvents EditBoxUsername As Microsoft.Office.Tools.Ribbon.RibbonEditBox
    Friend WithEvents EditBoxPassword As Microsoft.Office.Tools.Ribbon.RibbonEditBox
    Friend WithEvents btnLogin As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents Menu1 As Microsoft.Office.Tools.Ribbon.RibbonMenu
    Friend WithEvents btnUsers As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents lblOnOff As Microsoft.Office.Tools.Ribbon.RibbonLabel
    Friend WithEvents ButtonLogin As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents GroupLogout As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents btnLogout As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents GroupSQL As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents chkUseAppSettings As Microsoft.Office.Tools.Ribbon.RibbonCheckBox
    Friend WithEvents Group2 As Microsoft.Office.Tools.Ribbon.RibbonGroup
    Friend WithEvents btnMyStock As Microsoft.Office.Tools.Ribbon.RibbonButton
    Friend WithEvents btnWanted As Microsoft.Office.Tools.Ribbon.RibbonButton
End Class

Partial Class ThisRibbonCollection

    <System.Diagnostics.DebuggerNonUserCode()> _
    Friend ReadOnly Property Ribbon1() As Ribbon1
        Get
            Return Me.GetRibbon(Of Ribbon1)()
        End Get
    End Property
End Class

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Microsoft Excel

Microsoft Excel

--

Questions

--

Followers

Top Experts

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.