¦p¦ó±N²{¦³¤u§@ï¸m³»?? (On Top)

samsung2888

¦p¦ó±N²{¦³¤u§@ï¸m³»?? (On Top)

stillfish00

¦^´_ 1# samsung2888
ThisWorkbook.Activate
AppActivate "MicroSoft Excel"

samsung2888

¸Õ¹L¤£¦æ©O!!!!§Ú·Q­n§âExcelµøµ¡©ñ¨ìwindows³Ì¤W¼h.....always on top!!!

stillfish00

¦^´_ 3# samsung2888
¨S¿ìªk¥Ã»·´£¨ì³Ì¤W¡A¦Ó¬O°õ¦æ¨ì¤W­±ªºµ{¦¡½X®É
·|§â"ExcelÀ³¥Îµ{¦¡"´£¨ì³Ì¤W¼h¦Ó¤w¡C

¦pªG§A«üªº¬OExcel¤u§@ªí³QUserForm»\¦í¡A¥i¥H­×§ïUserformªºShowModalÄݩʬ°false

bobomi

(1) ±¾API
or
(2) ±¾µ{¦¡

(1) ±¾API
Private Declare Function FindWindow Lib "USER32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function SetWindowPos Lib "USER32" (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

Sub AlwaysOnTop(³Ì¤W¼h As Boolean)
  On Error Resume Next
  h = Excel.Application.hwnd
  If Err Then
  h = FindWindow("XLMAIN", "Microsoft Excel - " & ThisWorkbook.Name)
  End If
  On Error GoTo 0
  k = IIf(³Ì¤W¼h, -1, -2)
  Call SetWindowPos(h, k, 0, 0, 0, 0, 3)
End Sub

samsung2888

¦^´_ 5# bobomi

·PÁºô¤Íbobomi ¼ö¤ßªº¦^µª.....
­ì¨Ó­n¥Îapi ¤~¸Ñ¨M±o¨ì
´ú¸Õ¹L¯uªº¥i¥H³á
§Ú­nªº´N¬O³o­Ó......¼F®`!!!!!¸U¤À·PÁ§A