Macros in personal will not count sheets

[Ron512]

The below simple code run from personal will return a value of 1 regardless of the number of sheets in the workbook. The same macro copied to a module in a workbook returns the correct number of sheets.

Additionally all of the macros in my personal folder that use sheet counting code do not work, such as:
For Each WS In ThisWorkbook.Worksheets
ThisWorkbook.Worksheets.count

This is a new issue they have worked in the past. The personal folder is opening in hidden view and the workbook is not in edit mode.

What could have changed to create this issue?

Your assistance with correcting this is very much appreciated.

Ron

Sub getSheetCount()
    MsgBox ThisWorkbook.Worksheets.count
End Sub

 

[Dryver14]

Try using activeworkbook rather than this workbook, this workbook refers to where the code is

 

[Ron512]

Thanks Dryver14, that was the fix and I think I understand why.
ThisWorkbook references the workbook in which the vba is executing.

So if I am executing code that is stored in personal on a workbook ActiveWorkbook should be used and if I’m executing code that resided in the workbook use ThisWorkbook.
Do I have that correct?

 

[Dryver14]

Almost, Thisworkbook references where the vba is residing

 

[Ron512]

Thanks
This forum is always a great learning source.