jiangtao2012 发表于 2013-2-19 12:47
当然有意义呀,您能帮就帮一下吧
将Excel工作簿中左上角的Excel工作簿图标更换,改成认为合适的图标,以表示与其它工作簿的区别。有很多图标可供选择,可以通过以下方式查找图标,如点击左下角开始——搜索——在文件和文件夹中输入exe,则可发现很多带.exe后缀的图标如cmd.exe……等可供使用。只要将找到的图标名取代notepad.exe即可。
将工作簿左上角的图标更换为Notepad图标。
‘******下面的代码写入ThisWorkbook模块中******
Private Sub Workbook_Open()
Application.Caption = "我的工作簿"
ChangeApplicationIcon
End Sub
‘******下面的代码写入标准模块中******
Declare Function GetActiveWindow32 Lib "USER32" Alias "GetActiveWindow" () As Integer
Declare Function SendMessage32 Lib "USER32" Alias "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long,ByVal wParam As Long, ByVal lParam As Long) As Long
Declare Function ExtractIcon32 Lib "SHELL32.DLL" Alias "ExtractIconA" (ByVal hInst As Long, ByVal lpszExeFileName As String, ByVal nIconIndex As Long) As Long
Sub ChangeApplicationIcon()
Dim Icon&
'*****Change Icon To Suit*******
Const NewIcon$ = "notepad.exe"
'*****************************
Icon = ExtractIcon32(0, NewIcon, 0)
SendMessage32 GetActiveWindow32(), &H80, 1, Icon '< 1 = big Icon
SendMessage32 GetActiveWindow32(), &H80, 0, Icon '< 0 = small Icon
End Sub