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 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
| '***************************************
' CATIA .CvS Generator File Name
' Version 1.1b beta
' created by pdubernet on 2007
'
'
' please contact your administrator or
' euberti@assytem.com
' pdubernet@assystem.com
'***************************************
Public strXlsFullName As String
Private Declare Function FindWindowA Lib "user32" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLongA Lib "user32" _
(ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLongA Lib "user32" _
(ByVal hwnd As Long, ByVal nIndex As Long, _
ByVal dwNewLong As Long) As Long
Private Declare Function apiGetSys Lib "user32" Alias "GetSystemMetrics" (ByVal nIndex As Long) As Long
Sub Apparance()
Dim xls As Excel.Workbook
xls.DisplayFormulaBar = False
xls.Caption = "ASSYSTEM FRANCE"
ActiveWindow.Caption = ".CsV GENERATOR"
'Incorrect
MsgBox Application.Caption & " " & ActiveWindow.Caption
'Correct
MsgBox Application.Caption
End Sub
Private Sub Workbook_Open()
'désactive les boutons fermer plein écran et réduire d'excel
Dim hwnd As Long
hwnd = FindWindowA(vbNullString, Application.Caption)
SetWindowLongA hwnd, -16, GetWindowLongA(hwnd, -16) And &HFFF7FFFF
'Windows(1).WindowState = xlMaximized
Dim strHeight As Integer
Dim strWidth As Integer
strHeight = apiGetSys(1)
strWidth = apiGetSys(0)
' Mettre la fenêtre en mode NoFull
Application.WindowState = xlNormal
' Ensuite redimensionner l'application
Application.Height = (strHeight * 2) / 3
Application.Width = (strWidth * 2) / 3
'Application.DisplayFullScreen = True
' désactive la barre de formule
Application.DisplayFormulaBar = False
'désactive le menu
Application.CommandBars(1).Enabled = True
'active les onglets des feuilles
ActiveWindow.DisplayWorkbookTabs = True
'désactive les barres d'outil
Dim CmdB As CommandBar
For Each CmdB In Application.CommandBars
CmdB.Enabled = False
Next CmdB
'désactive l'entête des colonnes et lignes
ActiveWindow.DisplayHeadings = False
'affichage de la "feuille"
Application.Height = (strHeight * 2) / 3
Application.Width = (strWidth * 2) / 3
'Protège la feuille
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlNoSelection
Sheets("Memory").Cells(2, 5) = ActiveWorkbook.FullName
strXlsFullName = ActiveWorkbook.FullName 'ActiveWorkbook.FullName
frmSplash.Show
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'désactive la vue en plein écran
'Application.DisplayFullScreen = False
'réactive le menu
Application.CommandBars(1).Enabled = True
' réactive la barre de formule
Application.DisplayFormulaBar = True
'réactive les onglets des feuilles
'ActiveWindow.DisplayWorkbookTabs = True
'réactive l'entête des colonnes et lignes
ActiveWindow.DisplayHeadings = True
'réactive les boutons fermer plein écran et réduire d'excel
Dim hwnd As Long
hwnd = FindWindowA(vbNullString, Application.Caption)
SetWindowLongA hwnd, -16, GetWindowLongA(hwnd, -16) Or &H80000
'réactive les barres d'outil
Dim CmdB As CommandBar
For Each CmdB In Application.CommandBars
CmdB.Enabled = True
Next CmdB
End Sub |
Partager