|
wgl309 发表于 2012-8-13 07:24
不是,是从Sheet1第一行到200行或更多行后,按钮仍在屏幕的某一固定位置.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Goto [a1]
Call test
End Sub
Private Sub Workbook_Open()
Application.Goto [a1]
Call test
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call test
End Sub
Public r, c
Sub test()
Dim rng
'偏差
If r = "" Then r = Sheet1.CommandButton1.TopLeftCell.Row - ActiveWindow.ScrollRow
If c = "" Then c = Sheet1.CommandButton1.TopLeftCell.Column - ActiveWindow.ScrollColumn
'按偏差纠正
Set rng = Cells(ActiveWindow.ScrollRow + r, ActiveWindow.ScrollColumn + c)
Debug.Print rng.Address(0, 0)
Sheet1.CommandButton1.Left = rng.Left
Sheet1.CommandButton1.Top = rng.Top
End Sub
按钮仍在屏幕的某一固定位置.rar
(12.07 KB, 下载次数: 12)
|
|