excel 去工作表叉代码_欢乐小爪_百度空间
excel 去工作表叉代码 一般写在Private Sub Workbook_Open()
就是工作表菜单上那个关闭按钮
*/////////////////////
Public Declare Function ExtractIcon Lib "shell32.dll" Alias "ExtractIconA" (ByVal hInst As Long, ByVal lpszExeFileName As String, ByVal nIconIndex As Long) As Long
Public 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
Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Public Const WM_SETICON = &H80
Private Declare Function GetSystemMenu Lib "user32" (ByVal hwnd As Long, ByVal bRevert As Long) As Long
Private Declare Function RemoveMenu Lib "user32" (ByVal hMenu As Long, ByVal nPosition As Long, ByVal wFlags As Long) As Long


Sub 去叉()
Dim hMenu As Long, MF_BYCOMMAND
hMenu = GetSystemMenu(FindWindow("XLMAIN", Application.Caption), 0)
RemoveMenu hMenu, &HF060, MF_BYCOMMAND
End Sub

嘿嘿怎么还原呢?
hMenu = GetSystemMenu(FindWindow("XLMAIN", Application.Caption), 1)
把0改1 就好了


郑重声明:资讯 【excel 去工作表叉代码_欢乐小爪_百度空间】由 发布,版权归原作者及其所在单位,其原创性以及文中陈述文字和内容未经(企业库qiyeku.com)证实,请读者仅作参考,并请自行核实相关内容。若本文有侵犯到您的版权, 请你提供相关证明及申请并与我们联系(qiyeku # qq.com)或【在线投诉】,我们审核后将会尽快处理。
—— 相关资讯 ——