我有问题,请帮帮我!我的故事:我在excel 2016(64位)中有一个userform,在多工作簿中有userform活动 . 脚步:

  • 打开用户表单

  • 打开2个以上的工作簿

  • 最小化userform,最小化我们打开的所有工作簿

  • 最大化工作簿,最小化为3 .

  • 如何使用最小化模式显示userform?我使用了ShowWindow lHwnd,SW_SHOW

(SW_SHOW = 2),但ShowWindow不起作用 .

你能在第5步帮助我吗?非常感谢你!!!

资源:

Private Declare PtrSafe Function ShowWindow Lib "user32" (ByVal hwnd As Long, ByVal nCmdSHow As Long) As Long <br>
Private Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long 

Public Function showWin(strClassName As String, strWindowName As String, lngState As Long)

  'Get window handle.

  Dim lngWnd As Long

  Dim intRet As Integer

  lngWnd = FindWindow(strClassName, strWindowName)

  showWind = ShowWindow(lngWnd, lngState)

End Function

注意:userform有minimaline按钮,maximixe按钮