Private Sub ntpsubRowFor_psubシート情報追記(ByRef pwksTarget As Worksheet, ByVal pintSearchCol As Integer, ByVal pintStartRow As Integer)
Dim intRow As Integer
With pwksTarget
intRow = pintStartRow
Do Until .Cells(intRow, pintSearchCol) = ""
intRow = intRow + 1
Loop
End With
End Sub
Private Sub ntpsubシート情報追記(ByRef wksTarget As Worksheet, ByVal intRow As Integer)
Dim objSheet As Worksheet
Dim strBookName As String
Dim strSheetName As String
strBookName = wksTarget.Cells(3, 3)
If intRow = 0 Then
wksTarget.Cells(10, 4) = ".ProtectContents"
Else
strSheetName = wksTarget.Cells(intRow, 2)
Set objSheet = Workbooks(strBookName).Worksheets(strSheetName)
wksTarget.Cells(intRow, genmシート一覧列情報.intProtectContents) = objSheet.ProtectContents
wksTarget.Cells(intRow, genmシート一覧列情報.intVisible) = objSheet.Visible
End If
End Sub