Private Sub CommandButton2_Click()
Dim i As Integer
For i = 3 To Worksheets.Count
If Worksheets(i).Visible = 0 Then
X = 1
Worksheets(i).Visible = -1
End If
Worksheets(i).Copy
ActiveWorkbook.SaveAs FileName:=ThisWorkbook.Path & "\" & ActiveSheet.Name
ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value
ActiveWorkbook.Close
If X = 1 Then
Worksheets(i).Visible = 0
X = 0
End If
Next
End Sub
Private Sub CommandButton2_Click()
Dim i As Integer
For i = 3 To Worksheets.Count
If Worksheets(i).Visible = 0 Then
X = 1
Worksheets(i).Visible = -1
End If
Worksheets(i).Copy
ActiveWorkbook.SaveAs FileName:=ThisWorkbook.Path & "\" & ActiveSheet.Name
ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value
ActiveWorkbook.Close
If X = 1 Then
Worksheets(i).Visible = 0
X = 0
End If
Next
End Sub