I have this code
Sub SearchAllSheets()
For Each Worksheet In Worksheets
Sheets(Worksheet.Name).Select
Call Main
Next Worksheet
End Sub
which runs the macro for each sheet. I have one hidden sheet in the workbook which I don't want it to be run by the macro.
However, when the code reach the hidden sheet I get an error in the line
Sheets(Worksheet.Name).Select
How can I solve this problem???Please help
Thanks in advance
Sub SearchAllSheets()
For Each Worksheet In Worksheets
Sheets(Worksheet.Name).Select
Call Main
Next Worksheet
End Sub
which runs the macro for each sheet. I have one hidden sheet in the workbook which I don't want it to be run by the macro.
However, when the code reach the hidden sheet I get an error in the line
Sheets(Worksheet.Name).Select
How can I solve this problem???Please help
Thanks in advance