Method or data member not found

[josros60]

Hi,

Have code below getting error Method or data not found but checked is the right name, not sure why the error:

Public Sub Auto_Open()
    TableManager.AutoOpen ThisWorkbook
End Sub

 

[RoryA]

What is TableManager? Nothing in Excel has an AutoOpen method unless you created it.

 

[josros60]

is an adding for creating popup form for tables.

'Attribute VB_Name = "Module1"
Option Explicit

Private Const Module_Name As String = "Module1."

Public Sub Auto_Open()
    TableManager.AutoOpen ThisWorkbook
End Sub

Public Sub BuildDataDescriptionTable()
    
    Const RoutineName As String = Module_Name & "BuildDataDescriptionTable"
    On Error GoTo ErrorHandler
    
    If Not TableManager.TableDataCollected Then
        MsgBox "Build the tables first"
        Exit Sub
    End If
    
    TableManager.BuildParameterTableOnWorksheet TableManager.mainworkbook
    
    '@Ignore LineLabelNotUsed
Done:
    Exit Sub
ErrorHandler:
    DisplayError RoutineName

End Sub


Public Sub ExtendDataValidation()

    Const RoutineName As String = Module_Name & "ExtendDataValidation"
    On Error GoTo ErrorHandler
    
    If Not TableManager.TableDataCollected Then
        MsgBox "Build the tables first"
        Exit Sub
    End If
    
    TableManager.ExtendDataValidationThroughAllTables TableManager.mainworkbook
    
    '@Ignore LineLabelNotUsed
Done:
    Exit Sub
ErrorHandler:
    DisplayError RoutineName

End Sub

Thank you