-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathmActRefresh.bas
68 lines (51 loc) · 1.42 KB
/
mActRefresh.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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
Attribute VB_Name = "mActRefresh"
Sub p_in2plnRetrieve(ByVal vIRibbonControl As IRibbonControl)
On Error GoTo ErrorHandler
Call p_CheckConnection
Call p_RefreshRibbonNow
Call p_setExcelCalcOff
X = HypShowPov(isHypShowPov)
If vIsFirstRetrive Then
If vIsUseNameDefault Then
X = HypSetAliasTable(Empty, "Default")
Else
X = HypSetAliasTable(Empty, "none")
End If
vIsFirstRetrive = False
p_RefreshRibbonNow
Else
X = HypMenuVRefresh()
End If
If X <> 0 Then GoTo ErrorHandler
X = HypShowPov(isHypShowPov)
X = 0
Call p_setExcelCalcOn
Exit Sub
ErrorHandler:
Call p_ErrorHandler(X, "p_in2plnRetrieve")
End Sub
Sub p_in2plnUndo(ByVal vIRibbonControl As IRibbonControl)
On Error GoTo ErrorHandler
Call p_CheckConnection
Call p_setExcelCalcOff
X = HypMenuVUndo()
Call p_setExcelCalcOn
If X <> 0 Then GoTo ErrorHandler
l_exit:
Exit Sub
ErrorHandler:
Call p_ErrorHandler(X, "p_in2plnUndo")
End Sub
Sub p_in2plnRedo(ByVal vIRibbonControl As IRibbonControl)
On Error GoTo ErrorHandler
Call p_CheckConnection
Call p_setExcelCalcOff
X = HypMenuVRedo()
Call p_setExcelCalcOn
If X <> 0 Then GoTo ErrorHandler
l_exit:
Exit Sub
ErrorHandler:
Call p_ErrorHandler(X, "p_in2plnRedo")
X = 0
End Sub