|
本帖最后由 啦啦游游 于 2016-1-25 11:15 编辑
1. For Each w In Workbooks
If w.Name = Filename Then
NewerVersion = True ' The source file is already open and my be updated
End If
Next w
w.Name指代的是哪些地方的内容啊?
2. Sheets().Tab.ColorIndex = -4142 指代的是哪部分的颜色?
和 sheets().cells().Interior.ColorIndex=-4142 有什么区别
3. Path = Cells(1, 3).comment.Text 是批注内容的意思吗?
那没有批注运行出错怎么办
4. ActiveSheet.Protection.AllowEditRanges().Delete 意思是什么
5. ActiveSheet.Protection.AllowEditRanges.Add Title:="Bereich1", Range:=Range( "D3:AI10") 意思是什么
6. If CommentHours <> "" Then
On Error GoTo PasteData1
sheet.Cells(Row, ColumnTotalHours).comment.Text Text:=sheet.Cells(Row, ColumnTotalHours).comment.Text & _ Person & ": " & CommentHours & Chr(10)
GoTo PasteData2
PasteData1:
sheet.Cells(Row, ColumnTotalHours).AddComment
sheet.Cells(Row, ColumnTotalHours).comment.Visible = False
sheet.Cells(Row, ColumnTotalHours).comment.Text Text:=Person & ": " & CommentHours & Chr(10)
Resume Next
PasteData2:
End If
If CommentCosts <> "" Then
On Error GoTo PasteData3
sheet.Cells(Row, ColumnExtraCosts).comment.Text Text:=sheet.Cells(Row, ColumnExtraCosts).comment.Text & _ Person & ": " & CommentCosts & Chr(10)
GoTo PasteData4
PasteData3:
sheet.Cells(Row, ColumnExtraCosts).AddComment
sheet.Cells(Row, ColumnExtraCosts).comment.Visible = False
sheet.Cells(Row, ColumnExtraCosts).comment.Text Text:=Person & ": " & CommentCosts & Chr(10)
Resume Next
PasteData4:
End If
[新增!!!!]
7. Workbooks.Open Filename:=Path & Filename, ReadOnly:=False, UpdateLinks:=3
上一句里的 UpdateLinks:=3 是什么意思呢
这一大段能大概解释一下是什么吗~~~~
谢谢大家啦~~~
本帖最后由 兰色幻想 于 2015-12-30 10:27 编辑
w.Name 已打开的工作簿名称
Sheets().Tab 工作表标签
Interior.ColorIndex是填充颜色
ActiveSheet.Protection.AllowEditRanges().Delete 受保护的允许编辑区域
ActiveSheet.Protection.AllowEditRanges.Add Title:="Bereich1", Range:=Range( "D3:AI10") 增加受保护允许编辑区域
|
|