返回列表 上一主題 發帖

[分享] vba 執行螢幕問題

回復 1# asoonla

試試
  1. Public Declare Function SetWindowPos Lib "user32" _
  2. (ByVal hwnd As Long, ByVal hwndinsertAfter As Long, ByVal X As Long, ByVal Y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long
  3. Sub nn()
  4. Application.OnTime Now + TimeValue("00:00:30"), "ex"
  5. End Sub

  6. Sub ex()
  7. With ThisWorkbook.Application
  8. hw = .hwnd
  9. SetWindowPos hw, -1, 0, 0, 0, 0, 3
  10. .DisplayFullScreen = True
  11. End With
  12. End Sub
複製代碼
學海無涯_不恥下問

TOP

        靜思自在 : 人事的艱難與琢磨,就是一種考驗。
返回列表 上一主題