Sheet numbers enigma

[normpam]

Have a workbook with multiple sheets. The third sheet is named 'Draw'. When I use Sheets(1).Select it work fine. Also works with sheets 5,6,7 etc. BUT, it will not work to go to the third sheet named 'Draw'. Here's where it gets more crazy. If I copy the Draw sheet to a new workbook, even it is the third sheet the code still works. But in the workbook I need to use, the coder simply will not go to the third sheet named Draw. Also, if I move this third sheet to another position, it will not work either - how is this possible? I do note that there are many hidden sheets, but that does not seem to be the issue, as I have tested it by moving and adding and hiding sheets.....

 

[footoo]

Try using ; Worksheets(3).Select

 

[My Aswer Is This]

When asking for help with some code you have written it's always best to show us your code.
Normally I would use:

Sub Sheet_Select()
'Modified 6/28/2020 1:55:04 AM  EST
Sheets("Draw").Activate
End Sub

 

[Peter_SSs]

Apart from showing code as suggested by MAIT, it is also best to describe what does actually happen, rather than just "it will not work to go to the third sheet".

Does your workbook have any hidden sheets?