Search secondary workbooks for specific tabs in an ".xlsx" file

[atf32]

I normally use a basic code that looks into a secondary workbook and scrolls through all that tabs for me (example scroll below). However, what I just realized was that I'm always running this against other macro enabled files. And earlier when I tried it against an ".xlsx" file, it would not go past the start for the for loop, even though it got in the file fine.

Can someone suggest another method (code) to use to list out the tabs of a secondary

".xlsx" ​

file?

Example scroll I am only successfull with marco enabled files:

For Each sh In Worksheet
sh.name
if sh.name="Sheet1" then
[do this]
else
[do that]
endif
Next sh​

 

[Domenic]

It shouldn't matter whether the workbook is an .xlsm or .xlsx file. As it stands, the code loops through each worksheet within the active workbook (although, it should be Worksheets with an "s", not Worksheet). So you'll need to make sure that the target workbook is active when you run this code. Alternatively, you can avoid having to make sure that your target workbook is the active workbook by assigning it to a variable, and do it this way...

    Dim wb As Workbook
    Dim ws As Worksheet
    
    Set wb = Workbooks("Book2.xlsx")
    
    For Each ws In wb.Worksheets
        'etc
        '
        '
    Next ws

 

[atf32]

This worked out great. Thank you for the help and the quick reply. Really appreciate it.