自定义工作簿图标

admin

1. Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
   
2. Private Declare Function DrawMenuBar Lib "user32" (ByVal hWnd As Long) As Long
   1 K( e6 o: M8 V4 a
3. Private Declare Function SetFocus Lib "user32" (ByVal hWnd As Long) As Long
   
4. Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, ByVal wParam As Integer, ByVal lParam As Long) As Long
   
5. Private Declare Function ExtractIcon Lib "shell32.dll" Alias "ExtractIconA" (ByVal hInst As Long, ByVal lpszExeFileName As String, ByVal nIconIndex As Long) As Long
   ! g7 X$ G8 h6 U* e
6. Private Const WM_SETICON = &H80
   
7. Private Sub Workbook_Open()
   
8.     Dim IStyle As Long
   0 u4 P4 p3 k$ v# \
9.     Dim hIcon As Long
   
10.     Dim hWndForm As Long
    9 S5 l. m1 D3 q# W; x& I9 T- x
11.     hWndForm = FindWindow(vbNullString, Application.Caption)
    
12.     hIcon = ExtractIcon(0, ActiveWorkbook.Path & "\p.bmp", 0)
    ( Y% t8 M  P1 h! U1 T1 Q3 ~
13.     SendMessage hWndForm, WM_SETICON, True, hIcon
    
14.     SendMessage hWndForm, WM_SETICON, False, hIcon
    4 R( a0 q4 {) |. s8 }
15. End Sub

复制代码

% A9 j. {; Q' ^8 p- ~