Sub 儲存屬性()
Dim y As Object, j As Byte
For Each y In Worksheets("資料面").OLEObjects
If InStr(y.Name, "CommandButton") Then
j = Replace(y.Name, "CommandButton", "")
Worksheets("儲存").Range("C" & (x - 1) * 20 + j - 1) = y.Enabled
End If
Next
End Sub
Sub 讀取儲存資料()
y.Enabled = Worksheets("儲存").Range("C" & (x - 1) * 20 + j - 1)
Sub 儲存屬性()
Dim y As Object, j As Byte
For Each y In Worksheets("資料面").OLEObjects
If InStr(y.Name, "CommandButton") Then
j = Replace(y.Name, "CommandButton", "")
Worksheets("儲存").Range("C" & (x - 1) * 20 + j - 1) = y.Enabled
End If
Next
End Sub
Sub 讀取儲存資料()
Dim y As Object, j As Byte
For Each y In Worksheets("資料面").OLEObjects
If InStr(y.Name, "CommandButton") Then
j = Replace(y.Name, "CommandButton", "")
y.Enabled = Worksheets("儲存").Range("C" & (x - 1) * 20 + j - 1)
End If
Next
End Sub