Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trying to create a new Ribbon for Excel 2010 using VS 2010 Pro

Status
Not open for further replies.

DougP

MIS
Dec 13, 1999
5,985
US
This is an exmple from here> I am getting 2 Errors
[highlight #FCE94F]1.[/highlight] ThisWorkbook is not a member of 'ExcelAddIn1.Globals'
[highlight #8AE234]2.[/highlight] Type ActionsPane1 is not defined.
Code:
Imports Microsoft.Office.Tools.Ribbon
Public Class Ribbon1
    Dim actionsPane1 As New [highlight #8AE234]ActionsPaneControl1()[/highlight]    
    Dim actionsPane2 As New ActionsPaneControl2()

    Private Sub Ribbon1_Load(ByVal sender As System.Object, ByVal e As RibbonUIEventArgs) Handles MyBase.Load
        [highlight #FCE94F]Globals.ThisWorkbook.ActionsPane[/highlight].Controls.Add(actionsPane1)
        Globals.ThisWorkbook.ActionsPane.Controls.Add(actionsPane2)
        actionsPane1.Hide()
        actionsPane2.Hide()
        Globals.ThisWorkbook.Application.DisplayDocumentActionTaskPane = False
    End Sub
End Class

TIA

DougP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top