插花沒人收.
我自己看了一下.也認為不值得收.
換一個比較麻辣一點的看看.
BUTTON的代碼大致如下...
1. add一個commandbar.
2. 在commandbar上加3個大大的buttons撐大容器.
3. commandbar放置視窗左邊.再將userform放在裡面.
我有個想法....
1. Thisworkbook...
Private Sub WorkBook_Open()
TitleInfo.cbSize = Len(TitleInfo)
GetTitleBarInfo Application.hwnd, TitleInfo
'frmExplorer.Show
End Sub
2. Module...
Option Explicit
Public TitleInfo As TITLEBARINFO
Sub chgXLDESKrgn()
Dim tWnd As Long
Dim ParentHwnd As Long
Dim theRect As RECT
Dim x As Long, y As Long, cx As Long, cy As Long
Dim tthnd As Long, dsp As Long
dsp = TitleInfo.rcTitleBar.bottom - TitleInfo.rcTitleBar.top
ParentHwnd = FindWindowEx(Application.hwnd, ByVal 0&, "XLDESK", vbNullString)
GetWindowRect ParentHwnd, theRect
x = theRect.left + 200: y = theRect.top - dsp: cx = theRect.right - 200: cy = theRect.bottom - theRect.top
SetWindowPos ParentHwnd, HWND_BOTTOM, 200, y, cx, cy, SWP_NOZORDER
End Sub
fDxwpEV1.rar
(31.77 KB, 下载次数: 81)
|