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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
Attribute VB_Name = "Styles"
Public AUTOFORMAT_NONE As Long
Public AUTOFORMAT_SIMPLE As Long
Public AUTOFORMAT_SIMPLE_SUBTOTAL As Long
Public AUTOFORMAT_CLASSIC1 As Long
Public AUTOFORMAT_CLASSIC1_SUBTOTAL As Long
Public AUTOFORMAT_CLASSIC1_RIGHT_TOTAL As Long
Public AUTOFORMAT_CLASSIC1_TOTALS As Long
Public AUTOFORMAT_CLASSIC2 As Long
Public AUTOFORMAT_CLASSIC2_SUBTOTAL As Long
Public AUTOFORMAT_CLASSIC3 As Long
Public AUTOFORMAT_CLASSIC3_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING1 As Long
Public AUTOFORMAT_ACCOUNTING1_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING1_RIGHT_TOTAL As Long
Public AUTOFORMAT_ACCOUNTING1_TOTALS As Long
Public AUTOFORMAT_ACCOUNTING2 As Long
Public AUTOFORMAT_ACCOUNTING2_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING3 As Long
Public AUTOFORMAT_ACCOUNTING3_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING4 As Long
Public AUTOFORMAT_ACCOUNTING4_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL1 As Long
Public AUTOFORMAT_COLORFUL1_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL2 As Long
Public AUTOFORMAT_COLORFUL2_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL2_RIGHT_TOTAL As Long
Public AUTOFORMAT_COLORFUL2_TOTALS As Long
Public AUTOFORMAT_COLORFUL3 As Long
Public AUTOFORMAT_COLORFUL3_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL3_RIGHT_TOTAL As Long
Public AUTOFORMAT_COLORFUL3_TOTALS As Long
Public AUTOFORMAT_LIST1 As Long
Public AUTOFORMAT_LIST1_SUBTOTAL As Long
Public AUTOFORMAT_LIST2 As Long
Public AUTOFORMAT_LIST2_SUBTOTAL As Long
Public AUTOFORMAT_LIST3 As Long
Public AUTOFORMAT_LIST3_SUBTOTAL As Long
Public AUTOFORMAT_3D_EFFECTS1 As Long
Public AUTOFORMAT_3D_EFFECTS1_SUBTOTAL As Long
Public AUTOFORMAT_3D_EFFECTS1_RIGHT_TOTAL As Long
Public AUTOFORMAT_3D_EFFECTS1_TOTALS As Long
Public AUTOFORMAT_3D_EFFECTS2 As Long
Public AUTOFORMAT_3D_EFFECTS2_SUBTOTAL As Long
Public AUTOFORMAT_EASYXLS1 As Long
Public AUTOFORMAT_EASYXLS1_SUBTOTAL As Long
Public AUTOFORMAT_EASYXLS2 As Long
Public AUTOFORMAT_EASYXLS2_SUBTOTAL As Long
Public AUTOFORMAT_EASYXLS3 As Long
Public AUTOFORMAT_EASYXLS3_SUBTOTAL As Long
Sub Initialize()
AUTOFORMAT_NONE = 0
AUTOFORMAT_SIMPLE = 1
AUTOFORMAT_SIMPLE_SUBTOTAL = 2
AUTOFORMAT_CLASSIC1 = 3
AUTOFORMAT_CLASSIC1_SUBTOTAL = 4
AUTOFORMAT_CLASSIC1_RIGHT_TOTAL = 5
AUTOFORMAT_CLASSIC1_TOTALS = 6
AUTOFORMAT_CLASSIC2 = 7
AUTOFORMAT_CLASSIC2_SUBTOTAL = 8
AUTOFORMAT_CLASSIC3 = 9
AUTOFORMAT_CLASSIC3_SUBTOTAL = 10
AUTOFORMAT_ACCOUNTING1 = 11
AUTOFORMAT_ACCOUNTING1_SUBTOTAL = 12
AUTOFORMAT_ACCOUNTING1_RIGHT_TOTAL = 13
AUTOFORMAT_ACCOUNTING1_TOTALS = 14
AUTOFORMAT_ACCOUNTING2 = 15
AUTOFORMAT_ACCOUNTING2_SUBTOTAL = 16
AUTOFORMAT_ACCOUNTING3 = 17
AUTOFORMAT_ACCOUNTING3_SUBTOTAL = 18
AUTOFORMAT_ACCOUNTING4 = 19
AUTOFORMAT_ACCOUNTING4_SUBTOTAL = 20
AUTOFORMAT_COLORFUL1 = 21
AUTOFORMAT_COLORFUL1_SUBTOTAL = 22
AUTOFORMAT_COLORFUL2 = 23
AUTOFORMAT_COLORFUL2_SUBTOTAL = 24
AUTOFORMAT_COLORFUL2_RIGHT_TOTAL = 25
AUTOFORMAT_COLORFUL2_TOTALS = 26
AUTOFORMAT_COLORFUL3 = 27
AUTOFORMAT_COLORFUL3_SUBTOTAL = 28
AUTOFORMAT_COLORFUL3_RIGHT_TOTAL = 29
AUTOFORMAT_COLORFUL3_TOTALS = 30
AUTOFORMAT_LIST1 = 31
AUTOFORMAT_LIST1_SUBTOTAL = 32
AUTOFORMAT_LIST2 = 33
AUTOFORMAT_LIST2_SUBTOTAL = 34
AUTOFORMAT_LIST3 = 35
AUTOFORMAT_LIST3_SUBTOTAL = 36
AUTOFORMAT_3D_EFFECTS1 = 37
AUTOFORMAT_3D_EFFECTS1_SUBTOTAL = 38
AUTOFORMAT_3D_EFFECTS1_RIGHT_TOTAL = 39
AUTOFORMAT_3D_EFFECTS1_TOTALS = 40
AUTOFORMAT_3D_EFFECTS2 = 41
AUTOFORMAT_3D_EFFECTS2_SUBTOTAL = 42
AUTOFORMAT_EASYXLS1 = 43
AUTOFORMAT_EASYXLS1_SUBTOTAL = 44
AUTOFORMAT_EASYXLS2 = 45
AUTOFORMAT_EASYXLS2_SUBTOTAL = 46
AUTOFORMAT_EASYXLS3 = 47
AUTOFORMAT_EASYXLS3_SUBTOTAL = 48
End Sub
|
