-
Notifications
You must be signed in to change notification settings - Fork 2
/
Module1.bas
49 lines (34 loc) · 1.05 KB
/
Module1.bas
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
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